Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “phage” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
phage11511367(None) 
page76036101p_age
peage84723561peage
phages125213511phages
phase104617211phase
plage84520401plage
adage7414052adage
age47154332__age
cage75339062_cage
chafe135117352chafe
change124116752change
chape125221142chape
chare105231982chare
charge125114212charge
chase105127122chase
gage65936102_gage
hade85440192_hade
hae67364002_ha_e
hag77255742_hag_
hags86740842_hags
hake115637842_hake
hale76052832_hale
hame97043132_hame
hare76255732_hare
hate78450172_hate
have106137072_have
haze164833392_haze
huge86321652_huge
image81411282image
mage75739122_mage
ohmage1295062ohmage
pace86345772p_ace
paged95926782p_aged
pager84728202p_ager
pages85235072p_ages
pale66055012p_ale
pane64950282p_ane
pare66760842p_are
parge85831852parge
pase65346862p_ase
pate65350462p_ate
pave96133892p_ave
peace95026082peace
peag75431342peag_
peages94321842peages
peags86122842peags
pease75231112pease
pelage9515362pelage
phased124011972phased
phases114618402phases
phat95837862pha_t
phone105621932phone
phrase11109902phrase
phyle134111152phyle
pipage1199142pipage
place94824612place
plages94520152plages
plague93610852plague
plane74929142plane
plate74635112plate
potage92715902potage
prase76128752prase
prate75135982prate
purge85324602purge
rage55742352_rage
sage55044592_sage
shade95125582shade
shag86430562shag_
shags95123862shags
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
stage65330192stage
swage94919562swage
thae76825562tha_e
thane86122532thane
usage6410212usage
wage84834082_wage
whale115517432whale

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.0931921408.6
2DLD Change Limit53800821.58034050.6
3Display Results82820.0302733.3
 (SQL Overall)178691821.703104927.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.