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 “railhead” with Change Limit: [1] [2] [3] [4]

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

72 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
railhead124418(None) 
nailhead1243981nailhead
railheads1343971railheads
trailhead1343421trailhead
airhead1136992_airhead
nailheads1343652nailheads
railed74727542rail_e_d
railroad943802railroad
trailheads1443062trailheads
acidhead1542793acidhead
ahead96817053_a__head
ailed66240283_ail_e_d
airheads1246133_airheads
allheal1044553_allheal
ariled75620323aril_e_d
bailed94726653bail_e_d
baldhead1544273baldhead
barehead1446603barehead
bighead14126653_bighead
billhead1464433billhead
brailed103914013brail_e_d
brailled1147193braille_d
bullhead1464783bullhead
cathead1338753ca_thead
crackhead2143323crackhead
failed105421603fail_e_d
fairlead1243513fairlead
faithed1437163faithe_d
fathead1437863fa_thead
gilthead1343333_gilthead
hailed104122743hail_e_d
hardhead1645883hardhead
hashhead1443263hashhead
jailed144917423jail_e_d
jarhead1835173ja_rhead
mailed95326753mail_e_d
masthead1435883masthead
nailed74021493nail_e_d
pinhead13347073_pinhead
pithead13419593_pithead
raided85017703rai_de_d
railbird1143443railbird
railcar945483rail_car
railer64524933rail_e_r
railers74420663rail_ers
raillery1134953raillery
railroads1043523railroads
railway1345313rail_way
rained75024603rai_ne_d
rainwear1143093rainwear
raised76120333rai_se_d
rallied83514083rallie_d
ralphed1334363ralphe_d
ranched133113603ranche_d
ravished1555713ravishe_d
redhead1257053r_edhead
replead10399013repl_ead
riled65833253r_il_e_d
rilled74525653r_ille_d
roiled74320053roil_e_d
sailed74327763sail_e_d
saphead1357773sa_phead
shithead1535523shithead
skinhead1643063skinhead
stairhead1343323stairhead
tailed74424663tail_e_d
toolhead1244353toolhead
trailed83415673trail_e_d
vailed104619293vail_e_d
wailed104823593wail_e_d
warhead1436603wa_rhead
wellhead1543503wellhead

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162727.83018666.9
3Display Results72720.0302400.0
 (SQL Overall)178691728.28021581.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.