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

55 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
soutache134498(None) 
soutaches1446441soutaches
gouache1335042gou_ache
moustache1663082moustache
soutane7312062souta_ne
attache12106693_attache
douche124613223dou__che
gouaches1436203gou_aches
isotach1244953iso_tach_
isotachs1343773iso_tachs
louche115212663lou__che
moustaches1763813moustaches
mustache15185283mustache
orache114013593_o_rache
outact8317203_outac_t
outacted1139383_outacted
outacts9310213_outacts
outage72017533_outa_ge
outate62923403_outa_te
outecho1244893_outecho
outface123011973_outfac_e
outpace112613023_outpac_e
outrace92418553_outrac_e
pistache1545893pistache
postiche1547793postiche
potiche1438043po_tiche
potlache15114283potlache
rotche114311983ro_t_che
rouche114714313rou__che
scutage1036333scuta_ge
scutate9310323scuta_te
scutch13247083scut_ch_
scutched16186893scut_ched
scutcher15176963scut_cher
scutches15168883scut_ches
smutch13205843smut_ch_
smutched16165923smut_ched
smutches15177273smut_ches
smutchy17193153smut_chy
solace83415823so_lac_e
soothe94214853soot__he
soroche1237183so_roche
sortable10312483sortable
source8410673sou_rc_e
soutanes8312933soutanes
south85223573sout__h_
southed114313993sout__hed
souther104116303sout__her
souths95216603sout__hs
stacte82113913s__tacte
sumach135310113s_umach_
sumachs14457353s_umachs
tache106222373___tache
toothache1752423toothache
touche114916173tou__che

Search took 8 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.406440125.6
2DLD Change Limit146162556.56322270.6
3Display Results55550.0301833.3
 (SQL Overall)178691556.99925530.9
 
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.