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

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

349 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
wise7573734(None) 
bise66437101bise
mise66043581mise
rise45945231rise
vise75632671vise
wide85235411wide
wife105228021wife
wile75944371wile
wine74953421wine
wipe94830281wipe
wire75839811wire
wis66552331wis_
wised95123341wised
wiser85522801wiser
wises85633191wises
wish107228731wish
wisp97124071wisp
wiss75630541wiss
wist78049291wist
wite75443271wite
wive105931751wive
aide56045002aide
ais39083572ais_
aisle55223192aisle
anise55129702anise
apse67725382apse
arise56436432arise
arse46539272arse
base64847022base
bice86235562bice
bide76041502bide
bike106532602bike
bile66147182bile
bine66650862bine
birse74517402birse
bis56860662bis_
bises75435622bises
bisk106523352bisk
bite66547002bite
bize155926292bize
case65848082case
cine66242942cine
cire65836372cire
cis57748032cis_
cist67244962cist
cite65640342cite
dice75841892dice
die46759652di_e
dies55653522dies
dike95935762dike
dime76237642dime
dine55555332dine
dire56644142dire
dis46459892dis_
disc76123232disc
dish86328332dish
disk96625832disk
disme85716242disme
diss56434482diss
dite55547552dite
dive85634772dive
dose56442432dose
dwine95616142dwine
ease45042332ease
eide55832242eide
else45923082else
fice95737112fice
fie67152442fi_e
fife106027702fife
file75446642file
fine75147952fine
fire76245592fire
fisc96819752fisc
fish106926272fish
fist76248422fist
five107629742five
frise85322452frise
fuse76429992fuse
gibe75927782gibe
gie47149542gi_e
gies55641422gies
gist56046762gist
gite55438612gite
give85829352give
guise64717712guise
gwine95513662gwine
hide85134642hide
hie67652702hi_e
hies74842832hies
hike116830392hike
hire75538962hire
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
hive106029672hive
hoise85224772hoise
hose76547242hose
ice56737242_ice
ire36943172_ire
is27048212_is_
isle45121702_isle
ism56322382_ism
iwis77117012iwis_
jibe136323392jibe
jism135514772jism
jive146123592jive
kibe106523452kibe
kike76524792kike
kine85643432kine
kis78051482kis_
kiss85227402kiss
kist86540802kist
kite85338242kite
lase46148512lase
lice66045062lice
lie38264522li_e
lies46454192lies
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lire47845292lire
lis37162272lis_
lisle53916722lisle
lisp68926882lisp
list47055342list
lite47054542lite
live76540992live
lose45144582lose
lyse76320592lyse
mice87442232mice
mike105535292mike
mile66352572mile
mime85736402mime
mine67256172mine
mire66748232mire
mis58162622mis_
miser75430402miser
mises74740562mises
miso67229902miso
miss65339422miss
mist66154532mist
mite66249412mite
muse67136032muse
nice65534712nice
nide55535792nide
nine45842172nine
nisei54214352nisei
nisi45823242nisi
nite45943582nite
nixe115722022nixe
noise55723732noise
nose46739362nose
nowise9511072nowise
ose38147342_ose
owse76321622owse
paise75028332paise
pase65346862pase
peise75825772peise
pice84641092pice
pie55457402pi_e
pies66949602pies
pike106335212pike
pile65649692pile
pine67755712pine
pipe86434432pipe
pis56362032pis_
pish96127912pish
piso66727562piso
piss65033332piss
piste75824602piste
poise75127892poise
pose66441732pose
prise74632612prise
qis126934382qis_
raise54828052raise
rase46149982rase
rice64942912rice
ride55945132ride
rife74632322rife
rile45650532rile
rime65138882rime
rinse54820972rinse
ripe66038922ripe
risen54621882risen
riser55431052riser
rises55244042rises
risk85724102risk
rite45849452rite
rive75537722rive
rose46148902rose
ruse45938932ruse
seise54727852seise
sice65545592sice
side55444492side
sike87138782sike
sine46560622sine
sipe67341042sipe
sire46150412sire
sis37360542sis_
sises55233832sises
site47052412site
size135630962size
swine85625302swine
swipe105217082swipe
swish115114822swish
swiss86712902swiss
swive115316192swive
tide55237382tide
tie36557532ti_e
ties45248312ties
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tire46143352tire
tis37056642tis_
twice104711122twice
twine85822362twine
twist86820982twist
unwise9510802unwise
use36835162_use
vase75629652vase
vibe95124502vibe
vice95732852vice
vide85432762vide
vie65447632vi_e
vies75238622vies
vile76139802vile
vine75643682vine
vis66747612vis_
visa76323872visa
vised95518762vised
vises84427772vises
vive105426622vive
wade85237062wade
wae67556952w_ae
waes76048602waes
wage84834082wage
waist86132382waist
waive114214602waive
wake114935702wake
wale74546432wale
wame95035482wame
wane76344722wane
ware76254722ware
was68767562was_
wash106033812wash
wasp95626852wasp
wast75655852wast
waste86125052waste
wave105234732wave
we57043452w__e
wee66760812w_ee
wees76249122wees
were76238332were
west75748082west
whee105429592whee
while115418692while
whine116022812whine
whish144512922whish
whisk154510142whisk
whist115322952whist
white114920302white
whose114914532whose
wich125724742wich
wick135726302wick
widen94717972widen
wider94826352wider
wides94832822wides
wifed125117742wifed
wifes114522562wifes
wifey144913672wifey
wig76740382wi_g
wigs84931252wigs
wild85126512wild
wiled95231552wiled
wiles85437872wiles
will75737512will
wilt76246292wilt
wily106428812wily
wimp115521522wimp
win66456292wi_n
wince105220882wince
wind85533852wind
wined94434182wined
wines85546862wines
winey115325432winey
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
winze175014852winze
wiped114722082wiped
wiper105421292wiper
wipes104827082wipes
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wiry
wisely122711712wisely
wisent93516342wisent
wisest95016442wisest
wisha114910852wisha
wished134417512wished
wisher123617062wisher
wishes124920952wishes
wisped123411892wisped
wisps105214182wisps
wispy137210972wispy
wissed104114642wissed
wisses94619602wisses
wisted104120272wisted
wists86728522wists
wit66563772wi_t
wited94727142wited
wites85536962wites
with105730472with
withe115220232withe
wits76044872wits
wived125121502wived
wiver115924512wiver
wives115328922wives
wiz156434152wi_z
wizen175813862wizen
wizes174723342wizes
woe66651242w_oe
woes76440662woes
woke115527962woke
wore77144672wore
worse86525262worse
wos66953532wos_
wost76544362wost
wove105624312wove
wries85827742wries
wrist84827562wrist
write85522832write
wuss75219332wuss
wye96331972w_ye
wyes105727502wyes
wyle105519382wyle
wyte106018642wyte
xis106935332xis_
yipe96722182yipe
ywis105313102ywis_
zine137036152zine

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298723490.84335435.3
3Display Results3493490.0764592.1
 (SQL Overall)1786913491.185150794.1
 
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.