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

340 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
time6623501(None) 
dime76237641dime
lime66244931lime
mime85736401mime
rime65138881rime
stime76521801stime
tame66343661tame
tide55237381tide
tie36557531ti_e
tike85534481tike
tile45451441tile
timed85223611timed
timer75626041timer
times75630821times
tine45855131tine
tire46143351tire
tome67543191tome
acme86924322acme
aide56045002aide
aim57858212aim_
aimed85626052aimed
aimer75926822aimer
aims67738182aims
alme65832162alme
amie66339852amie
anime75423202anime
betime105914832betime
bice86235562bice
bide76041502bide
bike106532602bike
bile66147182bile
bima86723832bima
bine66650862bine
biome94916992biome
bise66437102bise
bite66547002bite
bize155926292bize
came87648752came
chime125322592chime
cimex16119132cimex
cine66242942cine
cire65836372cire
cite65640342cite
clime95720892clime
come87547702come
crime94822692crime
cyme119420372cyme
dame77140312dame
deme76536282deme
dice75841892dice
die46759652di_e
dike95935762dike
dim68146492dim_
dimer85625602dimer
dimes85833042dimes
dims75435022dims
dine55555332dine
dire56644142dire
disme85716242disme
dite55547552dite
dive85634772dive
dome77240732dome
eide55832242eide
eme55837182_eme
fame95639392fame
feme96130542feme
fice95737112fice
fie67152442fi_e
fife106027702fife
file75446642file
fine75147952fine
fire76245592fire
five107629742five
fume96727632fume
game76644322game
gibe75927782gibe
gie47149542gi_e
gimel8313352gimel
gimme102411342gimme
gimp96124042gimp
gite55438612gite
give85829352give
glime85620192glime
grime85021322grime
hame97043132hame
heme95034412heme
hide85134642hide
hie67652702hi_e
hike116830392hike
him86247662him_
hims95230972hims
hire75538962hire
hive106029672hive
home98042442home
ice56737242_ice
imp76626972_imp
intime81014272intime
ire36943172_ire
item65620382item
jibe136323392jibe
jimp155618462jimp
jive146123592jive
kame105728232kame
kibe106523452kibe
kike76524792kike
kine85643432kine
kite85338242kite
lame66849292lame
lice66045062lice
lie38264522li_e
life75433732life
like86040842like
lima65734132lima
limb85429382limb
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limn66527692limn
limo65529732limo
limp88432492limp
limy95727712limy
line46965572line
lipe66839732lipe
lire47845292lire
lite47054542lite
live76540992live
me47748332__me
meme85330552meme
mice87442232mice
mike105535292mike
mile66352572mile
mim76048422mim_
mimed105622732mimed
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mine67256172mine
mire66748232mire
mise66043582mise
mite66249412mite
mome85239352mome
name65637412name
nice65534712nice
nide55535792nide
nim57142952nim_
nims66226882nims
nine45842172nine
nite45943582nite
nixe115722022nixe
nome66038422nome
optime1079352optime
oxime1498432oxime
pice84641092pice
pie55457402pi_e
pike106335212pike
pile65649692pile
pima85428652pima
pimp106024902pimp
pine67755712pine
pipe86434432pipe
pome85636692pome
prime96525602prime
retime85321802retime
rice64942912rice
ride55945132ride
rife74632322rife
rile45650532rile
rim56052272rim_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
rims65936302rims
rimy96621282rimy
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
same65245642same
seme65836652seme
sice65545592sice
side55444492side
sike87138782sike
sim56553142sim_
sima64730782sima
simp85228772simp
sims65737172sims
sine46560622sine
sipe67341042sipe
sire46150412sire
site47052412site
size135630962size
slime74925752slime
some66040382some
stile54931572stile
stimes85920572stimes
stimy105114742stimy
stipe76523372stipe
tace65342512tace
tae38267052t_ae
take84739262take
tale46154162tale
tam58663422tam_
tamed85528512tamed
tamer75230102tamer
tames75242012tames
tamp86133002tamp
tams67247932tams
tape64538142tape
tare45957622tare
tate44748602tate
tee38366872t_ee
teem66132602teem
tele45040872tele
temp85323332temp
thae76825562thae
the67436052t_he
thee78039062thee
them97427042them
theme105921732theme
thine85026862thine
thyme134612472thyme
ti28448292ti__
tic56343462ti_c
tick106231222tick
tics65729632tics
tided76322512tided
tides64830152tides
tidy86822422tidy
tied55535212tied
tier44936142tier
ties45248312ties
tiff104727722tiff
tiger65718632tiger
tikes95628902tikes
tiki87620842tiki
til36350262ti_l
tilde65017342tilde
tiled64832942tiled
tiler56131022tiler
tiles55542102tiles
till45941202till
tils45739612tils
tilt46252422tilt
timber104012682timber
timbre10328632timbre
timely113410112timely
timers84420992timers
timid84815732timid
tin36362172ti_n
tinea54923162tinea
tined65434532tined
tines54848422tines
ting56139902ting
tinge64626622tinge
tinmen82310402tinmen
tins45251302tins
tint46758862tint
tiny76134632tiny
tip56551222ti_p
tipi69924432tipi
tips66436762tips
tired65228902tired
tires55437492tires
tirl45029922tirl
tiro46832362tiro
tis37056642ti_s
tit36771052ti_t
titer55430612titer
tithe85319702tithe
titi47130622titi
title54721072title
titmen8239882titmen
titre54619392titre
tits46145042tits
tivy1014516862tivy
toe310166852t_oe
toile54626492toile
toke86738492toke
tole46052902tole
tom514358052tom_
tomb89029652tomb
tomes76037382tomes
toms68343492toms
tone46953742tone
tope65946382tope
tore47359322tore
tote46643672tote
tree47745812tree
tribe74420272tribe
trice75127492trice
trike95320162trike
trim65329522trim_
trimer85717152trimer
trims75021472trims
trine54734602trine
tripe75425382tripe
trite54730032trite
true46725852true
tube65828662tube
tule45735872tule
tump85927032tump
tune45635862tune
twae74719572twae
twee76827082twee
twice104711122twice
twine85822362twine
tye65837442t_ye
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
uptime1067672uptime
utile54718932utile
vibe95124502vibe
vice95732852vice
vide85432762vide
vie65447632vi_e
vile76139802vile
vim87437022vim_
vimen104114752vimen
vims95423312vims
vine75643682vine
vise75632672vise
vive105426622vive
wame95035482wame
wide85235412wide
wife105228022wife
wile75944372wile
wimp115521522wimp
wine74953422wine
wipe94830282wipe
wire75839812wire
wise75737342wise
wite75443272wite
wive105931752wive
yipe96722182yipe
zine137036152zine
zyme1819114942zyme

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 Limit298723400.90333080.8
3Display Results3403400.0804250.0
 (SQL Overall)1786913401.249143067.3
 
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.