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

91 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
koussos1137390(None) 
kousso10354391kousso_
kussos10336421k_ussos
cussos84210002_cussos
kouros1039182kou_ros
kusso9398032k_usso_
mousses94012702mousses
bassos85313703_bassos
bosses85925403bo_sses
bourses94014303bourses
bouses84931783bou_ses
busses85023383_busses
cosmos10311753co_smos
courses94218893courses
couscous1246683couscous
cousins9516003cousins
cusses84522773_cusses
cusso74912293_cusso_
custos84014313_custos
dosses76126273do_sses
dousers84817273dousers
douses74928933dou_ses
focusses13155223focusses
fossas94610703fo_ssas
fosses96022083fo_sses
fusses94920553_fusses
gausses8308693gausses
hocusses13155303hocusses
housels105312133housels
housers104717813housers
houses96032273hou_ses
josses135117683jo_sses
journos14134943journos
jousts135011273jou_sts
kisses104217333k_isses
kobos115616893ko__bos
kolkhos1364013kolkhos
kolos94921213ko__los
koodoos12116393koodoos
koss85224813ko__s_s
kotos95717703ko__tos
koumis1237623kou_mis
koumises1444593koumises
koumiss1344313koumiss
koumisses1552123koumisses
koumys1543303kou_mys
koumyses1741693koumyses
koumyss1641143koumyss
koumysses1841233koumysses
kouroi1036513kou_roi
kudos105011253k_u_dos
kvasses14365503kvasses
lassos64913813_lassos
loesses7310033loesses
losses65925233lo_sses
louses66230283lou_ses
mosses85527683mo_sses
mosso74715183mo_sso_
mousers95216443mousers
mouses85531423mou_ses
mousse84813033mouss_e
moussed10338913moussed
musses84624783_musses
nouses64627163nou_ses
ousels64815273_ousels
ousts55225703_ou_sts
ouzos143210413_ou_zos
plusses93510693plusses
posses85128803po_sses
poussie936623poussie
poussies1038113poussies
pusses84322843_pusses
rousers75220143rousers
rouses65436283rou_ses
rousts617016723rou_sts
soursop943033soursop
soursops1043213soursops
souses64229243sou_ses
susses64221053_susses
torsos64815733to_rsos
tosses65225393to_sses
touses64229673tou_ses
tousles74113933tousles
trusses73813643trusses
tusses64921243_tusses
tussis6379953_tussis
tussor6378233_tussor
tussors7388773_tussors
voussoir1141493voussoir
voussoirs1241603voussoirs
wusses93314893_wusses

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 Filter1786911340270.1731032896.0
2DLD Change Limit134027916.67020094.0
3Display Results91910.0332757.6
 (SQL Overall)178691916.87625987.6
 
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.