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

237 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
poisha113572(None) 
geisha1035212geisha
orisha936772orisha
paisa76021072pais_a
pasha105417182p_asha
pish96127912p_ish_
pois66539042pois__
poise75127892pois_e
poised94918472poised
poiser84217242poiser
poises84226542poises
poison8312222poison
polish114916722polish_
popish133812112popish_
posh95427322po_sh_
wisha114910852_wisha
apish105116633apish_
arista6415293arista
bolshy1444883bolshy
borsht11813503borsht
bosh96328973bo_sh_
boyish142911233boyish_
bugsha1233823bugsha
buqsha2032793buqsha
concha134213283concha
cosh96127623co_sh_
costa75523733co_sta
coyish143710393coyish_
crissa837623crissa
crista8311803crista
cuish10313173cuish_
dish86328333_dish_
dishy125712353_dishy
dorsa64617283dors_a
dovish1338103dovish_
fish106926273_fish_
fishy146011663_fishy
foison948933foison
foist85730973fois_t
foists95413983foists
fossa85812633fo_ssa
geishas1135083geishas
gosh86123423go_sh_
gotcha1234633gotcha
goyish13379013goyish_
heishi1235843heishi
hoise85224773hois_e
hoised105117433hoised
hoises94823673hoises
hoist86433213hois_t
hoists95516023hoists
hosta85917833ho_sta
isba61310883__isba
joist125125653jois_t
joists134711033joists
josh145117613jo_sh_
kasha124710723_kasha
kishka1232963_kishka
knish1238603knish_
kois85129403kois__
lowish12310533lowish_
mishap1338873_mishap
mocha1249923mo_cha
modish123813543modish_
moira71012023moi_ra
moist76033583mois_t
monish114217593monish_
mopish134311593mopish_
mosh95227603mo_sh_
moshav1446053mo_shav
noise55723733nois_e
noised75416233noised
noises65021853noises
noisy86813363nois_y
nosh76223543no_sh_
oidia6314953_oidia
orishas1036473orishas
ossa43714163_o_ssa
ossia53710403_ossia
pacha126518063p_acha
padishah1742483padishah
padshah16113353padshah
paisan84417073paisan
paisana94010223paisana
paisas84317493paisas
paise75028333pais_e
pakeha1533933pakeha
palish114718273palish_
parish115022353parish_
pash95638133p_ash_
pashas115117063p_ashas
pasta76624533p_asta
peise75825773peis_e
peised94817683peised
peises84125043peises
perish114619063perish_
phis95724903phis__
pia56848033p_i__a
pica85831493p_i_ca
pieta75421753p_ieta
pika106322953p_i_ka
pilea75123953p_ilea
pima85428653p_i_ma
pina65842633p_i_na
pinna75320183p_inna
pinta75727053p_inta
pis56362033p_is__
pisco96314983p_isco
pished124817063p_ished
pisher114317753p_isher
pishes114722103p_ishes
piso66727563p_is_o
pisos76021063p_isos
piss65033333p_is_s
piste75824603p_iste
pita65436433p_i_ta
pith95432693p_ith_
piths105817543p_iths
pithy135614463p_ithy
pitta75018693p_itta
pizza1538183p_izza
plash104616563plash_
plashy14448873plashy
plasma103810913plasma
plica9613373pli_ca
plight123513363plight
plisky1533713plisky
plisse8368403plisse
plush105614713plush_
plushy14406973plushy
poach124917863poach_
poachy16388963poachy
podesta1036763podesta
podia8415283po_dia
pods76540153pods__
podsol946853podsol
poesy105014063poes_y
poh86740533po__h_
poi57244663poi___
poilu72316003poi_lu
poilus82210573poilus
poind84217913poi_nd
poinds93511143poinds
point75338733poi_nt
pointe84619313pointe
points85618533points
pointy114913283pointy
poisers94214433poisers
poising103617103poising
poisons9310353poisons
polis74731163polis__
polished1468433polished
polisher1388073polisher
polishes13711783polishes
polka11310413po_lka
pols66044563pols__
poms87037743poms__
poncho133310123poncho
pons65850603pons__
pooch124815303pooch_
pooh96027383po_oh_
poohs103915713po_ohs
poorish123712303poorish_
poos65949113poos__
popishly1844193popishly
poppa8409893po_ppa
pops86340953pops__
popsie103013053popsie
popsy125713403pops_y
porch125918623porch_
porism104518063poris_m
porisms113713453porisms
posada937163posada
pose66441733po_s_e
posed85828413po_sed
poser75128773po_ser
poses74642763po_ses
posher115018163po_sher
poshly1437723po_shly
posies84431433posies
posing93922643posing
posit75833333po_sit
posits85718713posits
posse74722273po_sse
posses85128803posses
posset84923253posset
possum1057953possum
post67953363po_s_t
postal84317533po_stal
posts75228783po_sts
posy96028423po_s_y
potash1138273potash_
potiche1438043potiche
pots66452363pots__
potshard1444533potshard
potshot1249733potshot
potsie83916033potsie
potsy105815613pots_y
pouch124617083pouch_
pouchy16538663pouchy
pows95537663pows__
presa74319043pres_a
prima95019343pri_ma
prise74632613pris_e
prised94322203prised
prises84133173prises
prism94820263pris_m
prisms104915503prisms
prison8514023prison
priss74623893pris_s
prissy11347853prissy
pshaw13447513p__shaw
psis68120343psis__
ptisan8417973ptisan
puisne856353puisne
punish111411503punish_
push95526623p_ush_
pushy134614353p_ushy
rikisha1442343rikisha
rishi8311253_rishi
roshi8310753ro_shi
sha69837783___sha
swish115114823swish_
swishy15365843swishy
tonish93415903tonish_
tosh74826813to_sh_
toyish122911123toyish_
trishaw1344753trishaw
uppish1336633uppish_
visa76323873_vis_a
vista85416603_vista
voila84813943voi_la
whish144512923whish_
whisht154510813whisht
wish107228733_wish_
woosh113710733woosh_
zoysia1844163zoysia

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.390458182.1
2DLD Change Limit1127162375.04622337.7
3Display Results2372370.0633761.9
 (SQL Overall)1786912375.49932495.2
 
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.