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

99 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
kybosh184271(None) 
kibosh1534261kibosh
bosh96328972__bosh
kobos115616892kobos_
kyboshed2141752kyboshed
kyboshes2042742kyboshes
abash106016513_abash
abos67734413_abos_
ambos95321243ambos_
ambush1336103ambush
aslosh966233aslosh
bash915240163__bash
bos57966813__bos_
bosk105825733__bosk
boss65938343__boss
both96533433__both
bush96630713__bush
cohosh14517123cohosh
cosh96127623__cosh
cyborg1443083cyborg
cymose13429653cymose
embosk1464853embosk
emboss1087373emboss
frosh115713403_frosh
fynbos1433283fynbos_
galosh1038553galosh
gobos86219373gobos_
golosh1036463golosh
gosh86123423__gosh
gybes115012723gybes_
gyros95616483gyros_
gyrose105310253gyrose
hobos106321353hobos_
hypos1312014743hypos_
josh145117613__josh
kabob134113923kabo_b
kabobs14439293kabobs
kabs107130843kab_s_
kaross101910013kaross
kayos127714703kayos_
keblah1545313keblah
kebob135110913kebo_b
kebobs14427283kebobs
kenos95220623kenos_
ketose105711813ketose
kibbeh17406063kibbeh
kibes115521113kibes_
kiblah1535583kiblah
kiboshed1842763kiboshed
kiboshes1744013kiboshes
kilos95021473kilos_
kinos96626143kinos_
kiosk836233k_iosk
knish1238603k_nish
knobs11519713knobs_
knosp11576823k_nosp
kobo107422103kobo__
kobold1365963kobold
kobs105831083kob_s_
kolos94921213kolos_
koph135816543k__oph
kos76944823k__os_
koss85224813k__oss
kotos95717693kotos_
kudos105011253kudos_
kurbash1643803kurbash
kyaks11459163kyaks_
kyars124813963kyars_
kyats125012443kyats_
kyboshing2251773kyboshing
kyes115124933ky_es_
kytes125012913kytes_
lobos75921843lobos_
maybush1742453maybush
mosh95227603__mosh
mysost1138263mysost
nosh76223543__nosh
posh95427323__posh
pyros105718293pyros_
ribose839893ribose
skosh12407263_skosh
skybox2242293skybo_x
slosh84514483_slosh
smoosh11236733smoosh
splosh1186543splosh
swoosh12195213swoosh
sybo9714743sybo__
syboes1139343syboes
tosh74826813__tosh
typos106015813typos_
tyros85118593tyros_
umbos94613063umbos_
whoosh15244353whoosh
woosh113710733_woosh
xylose1636763xylose
yobs96028083_yobs_
yodh119916103_y_odh
yogh116616143_y_ogh
zygose19455553zygose

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 Filter1786911127160.1561145455.1
2DLD Change Limit112716996.62317018.9
3Display Results99990.0333000.0
 (SQL Overall)178691996.81226231.8
 
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.