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 “geisha” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
geisha103519(None) 
geishas1135061geishas
heishi1235842heishi
orisha936772orisha
poisha1135722poisha
wisha114910852_wisha
ageism968803ageis_m
ageisms1056603ageisms
ageist7315383ageis_t
ageists848493ageists
aguish1059283aguish_
apish105116633apish_
arista6415293arista
bertha11429173bertha
bugsha1233823bugsha
buqsha2032793buqsha
ceiba938693cei_ba
cesta75419483ce_sta
crissa837623crissa
crista8311803crista
cuish10313173cuish_
deash95617243deash_
deism84116033deis_m
deisms94411043deisms
deist64633593deis_t
deists74916433deists
delish105215613delish_
dish86328333_dish_
dishy125712353_dishy
egesta7428653egesta
egis56520653egis__
egises7312493egises
eight94928053_eight
epha9310053_e_pha
feijoa1642223feijoa
feist86230073feis_t
feists94915313feists
feisty12449293feisty
fetish12310373fetish_
fiesta938123fiesta
fish106926273_fish_
fishy146011663_fishy
garish104516923garish_
gash86833023g_ash_
geds66730813geds__
gees55647883gees__
geese64316003gees_e
geest64829613gees_t
geests75912163geests
gelada837623gelada
gels56836103gels__
gemma106311773ge_mma
gems75329113gems__
genera71211713genera
geneva1085853geneva
genoa64315823ge_noa
gens55740073gens__
genua64614153ge_nua
gerah9315303gerah_
gerahs1039413gerahs
gesso649603ge_sso
gest56149133ge_s_t
geste65920693ge_ste
gests66028813ge_sts
geta56627443ge__ta
gets55442483gets__
geyser1036513geyser
ghis85020163ghis__
gies55641423gies__
giga66720943g_i_ga
gighe10139733g_ighe
girsh95310023girsh_
gismo848863g_ismo
gist56046763g_is_t
gists66026193g_ists
glia56423153gli__a
glioma935953glioma
glossa7529163glossa
gnash9449833gnash_
gneiss765953gneis_s
gosh86123423g_osh_
gotcha1234633gotcha
goyish13379013goyish_
greisen856503greisen
greyish1435173greyish_
gringa838543gringa
grisly104310583grisly
grison7310103grison
grist65529873gris_t
grists74716483grists
grith95520373grith_
griths105211653griths
guinea737613guinea
guise64717713guis_e
guised84612163guised
guises74216313guises
gursh94512333gursh_
gush85424003g_ush_
gushy125213123g_ushy
heigh124812543heigh_
height134713433height
heist87030913heis_t
heists96814633heists
isba61310873__isba
kasha124710723_kasha
kishka1232963_kishka
knish1238603knish_
leash85519213leash_
leis45739603leis__
melisma1146473melisma
mensa75318663mens_a
mensh105413553mensh_
mesa67025483me_s_a
mesh96823003me_sh_
meshy135612783me_shy
mishap1338863_mishap
neigh94912383neigh_
neighs10387733neighs
neist54628443neis_t
newish1237903newish_
ogreish1134673ogreish_
ogrish1039263ogrish_
orishas1036473orishas
paisa76021073pais_a
pasha105417183_pasha
peise75825773peis_e
peised94817683peised
peises84125043peises
perish114619063perish_
pish96127913_pish_
reis45343233reis__
relish93916953relish_
resh76523453re_sh_
rikisha1442343rikisha
rishi8311253_rishi
seiche11811833seiche
seis45542393seis__
seise54727853seis_e
seised74218123seised
seiser65318343seiser
seises64026713seises
seisin63715123seisin
seism75019023seis_m
seismal937303seismal
seisms84912143seisms
seisor63712333seisor
sensa54117473sens_a
sha69837783___sha
siesta639503siesta
swish115114823swish_
swishy15365843swishy
tesla55612603te_sla
testa54822043te_sta
trishaw1344753trishaw
vesica11157913vesica
vesta86618303ve_sta
visa76323873_vis_a
vista85416603_vista
weigh125412513weigh_
weighs13338873weighs
weight133914183weight
welsh113110363welsh_
whish144512923whish_
whisht154510813whisht
wish107228733_wish_

Search took 6 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.1401276364.3
2DLD Change Limit1127161655.45320670.5
3Display Results1651650.0463587.0
 (SQL Overall)1786911655.63931688.4
 
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.