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

118 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
onetime93762(None) 
zonetime1944951zonetime
anytime1246042anytime
betime105914832_betime
centime114513032centime
foretime1348212foretime
intime81014272in_time
longtime1144362longtime
monetise10311472monetise
monetize1949982monetize
optime1079352o_ptime
overtime131312272overtime
retime85321802_retime
sometime1246752sometime
zonetimes2044202zonetimes
aforetime1444043aforetime
airtime948063airtime
anime75423203an__ime
bedtime1236973bedtime
berime105317333_berime
betide95115973_betide
betimes115114413_betimes
betise85616273_betise
bigtime1235753bigtime
centile94217183centile
centimes124012613centimes
centimo11609543centimo
conative131214623conative
daytime1344783daytime
delime9314043_delime
dentine83320243dentine
donative12139873donative
downtime1444753downtime
emetine9712943emetine
entice81316863en_tice
entire61617703en_tire
flextime2042813flextime
foretimes1447453foretimes
gentile83515293gentile
inertiae8411473inertiae
intima81910033in_tima
intimae9109753in_timae
intine61021983in_tine
inutile739883inutile
lifetime1343983lifetime
lonesome1047473lonesome
mistime11312613mistime
monetised1246973monetised
monetises11311043monetises
monetized2147153monetized
monetizes2049263monetizes
monitive1349993monitive
native9613013_native
netizen1635883_netizen
netlike11308913_netlike
nettle64514583_nettle
neume74414403_ne_ume
newie81813483_newi_e
noetic8514043noeti_c
noncrime12116603noncrime
nonelite8313613nonelite
noontime1095383noontime
notice8313443_notice
obelise9310173obelise
obelize1838243obelize
ofttimes1343123ofttimes
olefine1038023olefine
oleine6313793ole_ine
onerier7311613onerier
online6315843on_line
onside7511803on_side
onstage838363onstage
ontic74418573on_ti_c
optima10106533o_ptima
optimes1148473o_ptimes
orective1339353orective
oreide7311673ore_ide
overtame131510523overtame
overtimed15159243overtimed
overtimes141511303overtimes
overtire111413113overtire
oxime1498433o__xime
pastime114611973pastime
petite84320653_petite
poetise9314043poetise
poetize18310773poetize
pontine92419053pon_tine
ragtime1036163ragtime
regime95313943_regime
retie55735303_reti_e
retile65929673_retile
retimed104714653_retimed
retimes95020173_retimes
retine66237333_retine
retire64927013_retire
seedtime1144183seedtime
sentimo9449623sentimo
septime1138803septime
sometimes1345993sometimes
sonatine8313323sonatine
sonnetize1845363sonnetize
stime76521803__stime
teatime9310083teatime
tentie62521183tenti_e
time66235013___time
toneme8312103tone__me
tonetic9313433toneti_c
tonetics1048943tonetics
tonette7310373tonet_te
tontine72316143ton_tine
unitive10310563unitive
unitize16310033unitize
unretire846963unretire
untame82513603un_tame
untie54425493un_ti_e
untimed102713373un_timed
uptime1067673_uptime
wartime1237743wartime

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271187.12618808.2
3Display Results1181180.0303933.3
 (SQL Overall)1786911187.29624491.6
 
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.