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

157 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
temps9541713(None) 
hemps126917331hemps
kemps135012521kemps
tamps95524081tamps
temp85323331temp_
tempi94912201tempi
tempo95214971tempo
tempos103812291tempos
tempt95124841tempt
tempts10439451tempts
tumps95420791tumps
amps86230342_amps
beeps95320972beeps
bemas96424282bemas
bumps115921142bumps
camps116330262camps
ceps86125952ce_ps
comps115526052comps
damps105220412damps
deeps84921772deeps
demes86032692demes
demos86022992demos
dumps105220102dumps
emes65434662_emes
ems56435492_em_s
emus66821682_emus
femes105626222femes
fems96428702fem_s
gamps105323712gamps
gems75329112gem_s
gimps105915202gimps
heaps105223222heaps
helps105219342helps
hemes105031082hemes
hemp115725622hemp_
hempy154912762hempy
hems95534942hem_s
humps126322802humps
imps86221122_imps
items7499612item_s
jeeps144715372jeeps
jumps165116492jumps
keeps116020282keeps
kelps115116422kelps
kemp126418762kemp_
kempt134318462kempt
keps106027302ke_ps
lamps95624832lamps
leaps75522932leaps
limps95522672limps
lumps95624982lumps
memes94927702memes
memos95719112memos
mems85931502mem_s
mumps115619102mumps
neaps75618322neaps
neeps75617882neeps
nemas75321572nemas
peeps95822362peeps
peps85134512pe_ps
perps95521482perps
pimps114616982pimps
pomps115316192pomps
pumps115520602pumps
ramps96224632ramps
reaps75626192reaps
remaps105012872remaps
rems66237722rem_s
repps95114342repps
reps65937952re_ps
romps94617542romps
rumps95922292rumps
samps96124672samps
seeps74828752seeps
semes75731582semes
semis74623532semis
simps94719762simps
stamps105614022stamps
steeps85215192steeps
stems75219952stem_s
steps76619882ste_ps
stomps105612832stomps
stumps104912282stumps
sumps95023432sumps
tames75242012tames
tamis76728732tamis
tamp86133002tamp_
tams67247932tam_s
taps66050672t_aps
tarps76527112tarps
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492te_as
teats55636812teats
techs106915832techs
teds54932572te_ds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582te_es
teffs115111732teffs
teggs74710742teggs
tegs56031492te_gs
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temped113912892temped
tempeh13357462tempeh
tempehs14325152tempehs
temper103914092temper
tempers113513012tempers
tempest1139222tempest
temple102811332temple
temples112610892temples
tends65425582tends
tens45647412te_ns
tents56434212tents
tepa66021682te_pa
tepas76521682tepas
terms75523472terms
terns55226872terns
tests56530192tests
teths85418512teths
tets45847462te_ts
tews76431642te_ws
texas126514932texas
texts125515042texts
themes115319252themes
thesps11448262thesps
thumps13449352thumps
times75630822times
tips66436762t_ips
tombs97818732tombs
tomes76037382tomes
toms68343492tom_s
tops66248122t_ops
tramps105114452tramps
traps75727482traps
trips74923362trips
tromps104911702tromps
trumps104611882trumps
tump85927032tump_
tups65628762t_ups
turps74918732turps
twerps11345152twerps
typps12549302typps
umps85721942_umps
vamps125415482vamps
veeps104715722veeps
weeps104120562weeps
wimps125213802wimps
yelps105712992yelps
yeps95924402ye_ps
zeps156019342ze_ps

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit538001571.62633087.3
3Display Results1571570.0305233.3
 (SQL Overall)1786911571.99989390.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.