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

79 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
unlatches144429(None) 
unlatched1544211unlatched
klatches17157132_klatches
latches123320122__latches
slatches131511522_slatches
snatches131410712sn_atches
unhatched1844132unhatched
unhitches1743072unhitches
unlaces92513622unla_c_es
unlashes11238042unla_shes
unlatch1245052unlatch__
unmatched1744202unmatched
unpatched1744052unpatched
unwatched1844082unwatched
anlaces92313733anla_c_es
batches144019613__batches
blanches153311603_blanches
blotches1537433_blotches
bycatches2142683bycatches
catches144320773__catches
clutches15307923_clutches
cratches153012543_cratches
cultches15316533cul_tches
enlaces92313393enla_c_es
fletches16308853_fletches
flitches16388463_flitches
glitches14296653_glitches
hatches153420273__hatches
inarches1358043in_arches
inlaces92512903inla_c_es
klatsches1842223_klatsches
laches116528343__la_ches
larches124416443__larches
latched133914063__latched
latchet123117903__latchet
latchets133410013__latchets
lathes95127493__lat_hes
letches124015483__letches
matches143219783__matches
naches114622413_n_a_ches
nautches1336083_nautches
notches123513653_n_otches
nuthatches1842393nuthatches
outcatches1743783outcatches
outmatches1763743outmatches
outwatches1843473outwatches
patches143320383__patches
planches153111863_planches
potlatches17113323potlatches
ratches123620463__ratches
rematches1636653rematches
repatches1636713repatches
scratches1647323scratches
snatched14157633sn_atched
snatcher13167763sn_atcher
snatchers14146313sn_atchers
snathes104816493sn_at_hes
snitches13148983sn_itches
splotches1643913splotches
sunbathes1444113sunbat_hes
swatches16169963_swatches
thatches1637513_thatches
unarched14128553un_arched
unbathed1437223unbat_hed
uncatchy1842563uncatch_y
unclenches1743793unclenches
unclinches1742693unclinches
unclothes1445143unclot_hes
unhitched1843093unhitched
unlace82215173unla_c_e_
unlaced102913733unla_c_ed
unlades82612833unla__des
unlashed12289183unla_shed
unlatching1643153unlatching
unleashes1245123unleashes
unstitches1543563unstitches
unswathes1544213unswat_hes
unteaches1446083unteaches
watches153017373__watches

Search took 7 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 Filter1786911486410.403443402.0
2DLD Change Limit148641796.55022693.3
3Display Results79790.0302633.3
 (SQL Overall)178691796.98325589.4
 
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.