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

347 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
ices6612964(None) 
aces67645091aces
bices95029961bices
dices86434241dices
fices106031161fices
ice56737241ice_
iced78721891iced
ichs96214711ichs
ides57734231ides
ires45639281ires
rices75536151rices
sices75637271sices
vices105725531vices
ace59656832ace_
aced79540882aced
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
acts66929862acts
ages55844592ages
aides65336602aides
ales47067102ales
amices105018012amices
anes45255932anes
apes66047432apes
apices104916262apices
ares45871022ares
ates45047922ates
aves76142602aves
awes76037552awes
axes117337852axes
ayes76543512ayes
bees65453382bees
bes56557432_bes
bice86235562bice_
bicep115413542bicep
biceps12447712biceps
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
byes95230532byes
cee55952702_cee
cees65941592cees
cel56040552_cel
cels65534972_cels
cep75736332_cep
ceps86125952_ceps
cess65326052_cess
cigs75625102cigs
cines75239682cines
cires74932912cires
cis57748032_cis
cites74435592cites
cos510270392_cos
cues65438982cues
daces85030682daces
dees56356632dees
deices94119372deices
dice75841892dice_
diced95824682diced
dicer85426422dicer
dicers94720742dicers
dicey114819332dicey
dicks125824692dicks
dies55653522dies
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
does56554472does
duces86327472duces
dues56045502dues
dyes85331892dyes
eches106322162eches
ecus65421462ecus
ekes86726602ekes
emes65434662emes
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyes75837882eyes
faces106439432faces
feces105625362feces
fees76450602fees
fes66551672_fes
fice95737112fice_
fiches145219532fiches
ficoes114613462ficoes
ficus105015492ficus
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
foes76543442foes
fyces139813642fyces
gaes56348032gaes
gees55647882gees
gibes84422522gibes
gies55641422gies
gites65630182gites
gives95324872gives
goes55644092goes
haes77651022haes
hes66654202_hes
hicks145322172hicks
hides95129422hides
hies74842832hies
hikes125426982hikes
hires86134342hires
hives116925512hives
hoes75755732hoes
hues75235232hues
ibex133813482ibex
ibices10398162ibices
ibis66519582ibis
ich86227742ic_h
icier74313752icier
iciest82914742iciest
ick97329322ic_k
icker114018442icker
ickers123914182ickers
icky136315752icky
icon66922042icon
icones84616382icones
icons76516492icons
ictus7249702ictus
icy86322122ic_y
idea59122772idea
ideas65919012ideas
idem76121062idem
idles66720122idles
ids47535472i_ds
ifs67124242i_fs
iggs66612672iggs
ilea45931462ilea
ileus54616892ileus
ilex115822032ilex
ilks87218572ilks
ills47030422ills
imps86221122imps
incest82918742incest
inches114419672inches
incus73315052incus
inks86926502inks
inns46920932inns
ins35945602i_ns
ions46737852ions
ire36943172ire_
ired55131872ired
iris45732552iris
irks86220132irks
is27048212i__s
isles54220562isles
isms66213472isms
itches114916212itches
item65620382item
items7499612items
its35538832i_ts
ivies84215762ivies
iwis77117012iwis
jees115938542jees
jibes145520322jibes
jives154820812jives
joes116635892joes
juices1549422juices
kaes85734062kaes
kibes115521112kibes
kicks104420082kicks
kikes85122552kikes
kines95039132kines
kites95432542kites
kues86426772kues
kyes115124932kyes
laces76141762laces
lees45455882lees
les35663072_les
lice66045062lice_
liches114724292liches
licks115325392licks
lies46454192lies
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
luces75528432luces
lues45943552lues
lyes75530832lyes
maces97139962maces
maes66948402maes
micas96823052micas
mice87442232mice_
miches134320732miches
micks135525372micks
mics87435152mic_s
mikes115129892mikes
miles74645072miles
mimes95732022mimes
minces104420802minces
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
nice65534712nice_
nicer74618292nicer
nicest82315662nicest
niches114419142niches
nicks114920492nicks
nides65229132nides
nieces84112712nieces
nines55937342nines
nites55736342nites
nixes124519622nixes
noes45845392noes
obes66036832obes
ocas66729632ocas
odes57243242odes
oes35866192_oes
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxes116530722oxes
oyes74940132oyes
paces96741112paces
pecs84634102pecs
pees65257372pees
pes57259782_pes
picas94626522picas
pice84641092pice_
picks135226142picks
pics85633912pic_s
pieces104217272pieces
pies66949602pies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
prices104524542prices
puces94924632puces
pyes95528992pyes
races74943242races
recs65734182recs
rees45364192rees
res35565042_res
ribes75530172ribes
rice64942912rice_
riced85825542riced
ricer74726612ricer
ricers84120992ricers
riches115022082riches
ricks115126132ricks
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
roes45954142roes
rues46044482rues
ryes75529352ryes
saices84221802saices
secs65033892secs
sees45361052sees
shes75734352shes
sice65545592sice_
sicks115127622sicks
sics65234092sic_s
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
slices84022852slices
spices104326032spices
sues46247652sues
syces106416462syces
taces76237802taces
tees45353582tees
ticks115823292ticks
tics65729632tic_s
tides64830152tides
ties45248312ties
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
toes46956442toes
tres46542902tres
trices84826332trices
tyes76433372tyes
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
vibes104719952vibes
vice95732852vice_
viced115118182viced
vies75238622vies
vines85137642vines
vires84529682vires
vises84427772vises
voces105918052voces
voes75432822voes
voices114414012voices
waes76048602waes
wees76249122wees
wiches144418752wiches
wicks144619362wicks
wides94832822wides
wifes114522562wifes
wiles85437872wiles
winces114819112winces
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
woes76440662woes
wyes105727502wyes
yes66250612_yes
yikes125117752yikes
yipes106017842yipes
zees136331892zees
zines145232652zines

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.280638182.1
2DLD Change Limit298723470.86034734.9
3Display Results3473470.0804337.5
 (SQL Overall)1786913471.220146468.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.