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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
timber10401268(None) 
limber104316791limber
timbers113111841timbers
timbery14256891timbery
timbre10328631timbre
timer75626041tim_er
aimer75926822aim_er
amber94523212_amber
bibber94613572bibber
bomber125014652bomber
camber124418472camber
climber13449132climber
comber125118502comber
cumber124016702cumber
dibber114614712dibber
dimer85625602dim_er
dimmer114112612dimmer
dumber114414172dumber
ember95516802_ember
fibber134811932fibber
fiber104921132fi_ber
gibber114112862gibber
giber85417702gi_ber
imbed105013652_imbed
jibber174111242jibber
jiber145115702ji_ber
jimper17389862jimper
lamber104418492lamber
libber104414012libber
liber74723622li_ber
limbed114513182limbed
limbers113614742limbers
limbier11349112limbier
limier83518722limier
limmer104314792limmer
limner84112872limner
limper104117852limper
lumber103817772lumber
member12258852member
mimbar1297492mimbar
mimer94825762mim_er
nimbler11358062nimbler
number103913222number
omber95316442_omber
ribber103515492ribber
rimer75429242rim_er
rimier83916272rimier
rimmer103516032rimmer
simmer104115352simmer
simper103616292simper
somber103713992somber
taber73825822t_aber
tambur10358712tambur
tamer75230102tam_er
tamper104618512tamper
temper103914092temper
ticker124321502ticker
tidier73515112tidier
tier44936142ti__er
tiger65718632ti_ger
tiler56131022ti_ler
tiller64222532tiller
tilter63417692tilter
timbal102510752timbal
timbered13137382timbered
timbrel11306562timbrel
timbres11249342timbres
time66235012tim_e_
timed85223612tim_ed
timers84420992tim_ers
times75630822tim_es
timider1037092timider
tinder73821802tinder
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinter63923642tinter
tipper103918412tipper
titer55430612ti_ter
titfer9409522titfer
tither94920282tither
titter63421162titter
tombed113812132tombed
trimer85717152trim_er
trimmer113610832trimmer
tubber104313202tubber
tuber75420682t_uber
tumbler113412822tumbler
umber94617592_umber

Search took 6 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 Filter178691825510.1101624463.6
2DLD Change Limit82551895.06316304.8
3Display Results89890.0601483.3
 (SQL Overall)178691895.23334147.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.