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

73 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
karaokes114501(None) 
karaoke1044901karaoke_
karates115617472kara_tes
anankes1138763_anankes
arables91814973_arables
araks94820883_ara_k_s
arames84622573_ara_mes
arbores94016033_arbores
areoles71016953_areoles
arkoses113910833_arkoses
awakes135012473_awa_kes
berakes134815773bera_kes
brakes124923123_bra_kes
caracks152211563carack_s
caracoles13310083caracoles
carafes125015703cara_fes
carates95630613cara_tes
cargoes104415223cargo_es
carioles10817073carioles
crakes124921813_cra_kes
darioles9710693darioles
drakes114715863_dra_kes
earaches13411313earaches
earlobes1056153earlobes
garages9314113gara_ges
garotes8614573gar_otes
garpikes1534373garpikes
garrotes969383garrotes
harasses11311033harasses
kabakas12367403kaba_kas
kaiaks937043kaia_k_s
kanakas10327213kana_kas
kapoks11347263ka_pok_s
karakul1042553kara_kul
karakuls1142083karakuls
karate105320923kara_te_
karats106420493kara__ts
karoos102415803kar_o_os
kaross101910013kar_o_ss
karosses1236493karosses
karroos1139313karro_os
kathodes1646183kathodes
kavasses1544303kavasses
kayaked1474053kaya_ked
kayaker1354503kaya_ker
kayakers1463613kaya_kers
kayaks1236333kaya_k_s
kayoes134710823ka_yo_es
keratoses1346093keratoses
kraken955883k_ra_ken
krakens1034293k_ra_kens
kurtoses12105623kurtoses
narcoses103910553narcoses
parables121613563parables
parades104121463para_des
paradores12259663paradores
paradoses122510253paradoses
paradoxes19267293paradoxes
paragoges1347253paragoges
parbakes1638343parbakes
paroles95025883par_oles
parroket1449213parroket
parrokets1543923parrokets
partakes1449923partakes
rakes94440353__ra_kes
sarapes94617753sara_pes
sarodes84216143sar_odes
saroses73619333sar_oses
strakes114218073stra_kes
strokes114316323str_okes
taroks106115283tar_ok_s
trokes104019263_tr_okes
varioles11711123varioles

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.420425454.8
2DLD Change Limit146162737.20320291.8
3Display Results73730.0332212.1
 (SQL Overall)178691737.65623340.0
 
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.