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 “loach” 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.

86 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
loach10511636(None) 
coach125919451coach
leach105422521leach
loath84918601loath
loch95527131lo_ch
poach124917861poach
roach105717001roach
bach116131392_bach
beach124623892beach
bleach133611402bleach
blotch13197142blotch
botch126717452botch
brach126123302brach
broach133611112broach
clach124617822clach
cloaca1037262cloaca
coact96130572coact
conch124620072conch
cooch124916832cooch
couch125320112couch
each95530582_each
hooch135813702hooch
hotch136214722hotch
lac510155822l_ac_
lace66848472l_ace
lack105837682l_ack
lacs66942482l_acs
lacy95829632l_acy
laich105920712laich
lakh114919952l_akh
larch105919792larch
lash76539652l_ash
latch104620462latch
lath76640382l_ath
leachy14419732leachy
leash85519212leash
lech96825442l_ech
leech104913212leech
letch105215802letch
lich96230842l_ich
loaches123613982loaches
load56730602loa_d
loads65323372loads
loaf76734902loa_f
loafs85616992loafs
loam65630482loa_m
loams75619862loams
loamy105913342loamy
loan47436452loa_n
loans56026462loans
loathe94211382loathe
loca65527682lo_ca
local74820272local
lochs106715512lo_chs
loci66126282lo_ci
lock106134362lo_ck
loco67030742lo_co
lotah85315852lotah
loth76132132lo_th
louche115212662louche
lough95118482lough
lunch104917242lunch
lurch104814632lurch
lych126015762l_ych
lynch13468982lynch
mach116134472_mach
mooch125313612mooch
mouch124715802mouch
notch105613322notch
oath76132152_oath
orach105219232orach
ouch95724632_ouch
peach125422492peach
pleach134211242pleach
poachy16388962poachy
pooch124815302pooch
porch125918622porch
pouch124617082pouch
reach105123882reach
rotch105815932rotch
slouch11438522slouch
tach96132752_tach
teach105221122teach
torch107420932torch
touch106519392touch
vouch134611902vouch

Search took 4 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.0762351197.4
2DLD Change Limit53800863.14017133.8
3Display Results86860.0461869.6
 (SQL Overall)178691863.26254779.6
 
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.