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

94 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
kumisses144358(None) 
koumisses1552121koumisses
cuisses9319882cu_isses
kisses104217332k__isses
koumises1444592koumi_ses
koumysses1841232koumysses
kumiss1235922kumi_s_s
kumyses1633142kum_yses
misses85130872__misses
admasses1135413admasses
amasses93912853_amasses
bekisses1434243bekisses
blisses94911513_blisses
brisses94314313_brisses
busses85023383bu__sses
camasses12388973camasses
camises114218463cami_ses
coulisses1145633coulisses
cuishes122810823cu_ishes
cuisse8318333cu_isse_
cusses84522773cu__sses
cutises94414913cuti_ses
demises103719563demi_ses
dismisses1245493dismisses
disses75225963__disses
duresses939173duresses
famishes1658283famishes
fusses94920553fu__sses
gneisses933673gneisses
guesses8169373gu_esses
guises74216313gu_i_ses
gummoses1344743gummoses
hisses94719353__hisses
hummuses1544453hummuses
humuses1237593hum_uses
karosses1236493karosses
kavasses1544303kavasses
kermesses15284963kermesses
kermises14248313kermi_ses
kirmesses15253903kirmesses
kissed114412853k__issed
kisser104212453k__isser
kissers114211293k__issers
knishes1438263k_nishes
koumiss1344313koumi_s_s
koumyses1741693koum_yses
krises105016083k_ri_ses
kurtoses12105623kurtoses
kussos10336423ku__ssos
kvasses14365503k_vasses
masses85028713__masses
messes84924343__messes
metisses1036833metisses
mioses84318853__mioses
mises74740563__mi_ses
missed94423603__missed
missel85216523__missel
missels94614813__missels
misset85028153__misset
missets94516573__missets
missies93423983__missies
missis84417503__missis
missus85312293__missus
misuses93216023__misuses
mosses85527683__mosses
musses84624783__musses
outkisses1344303outkisses
pavisses13397103pavisses
pelisses1048483pelisses
pisses84525083__pisses
plisses94411773_plisses
premisses13288763premisses
prisses94816713_prisses
puisnes937423pu_isnes
pumices1338273pumi_ces
punishes1338113punishes
pusses84322843pu__sses
quasses16209503qu_asses
remises93423483remi_ses
rubasses1035483rubasses
rumpuses1235163rumpuses
semioses10611013semioses
semises93916553semi_ses
sisses64520603__sisses
speisses10245693speisses
surmises10310643surmi_ses
susses64221053su__sses
swisses10417143_swisses
tamises92715973tami_ses
tumesces1244843tumesces
tusses64921243tu__sses
tussises835433tussises
wisses94619603__wisses
wusses93314893wu__sses

Search took 10 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.1561145455.1
2DLD Change Limit146162949.18615911.4
3Display Results94940.0462043.5
 (SQL Overall)178691949.38819034.0
 
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.