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

147 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
rebozos183514(None) 
rebozo1737321rebozo_
bozos165216862__bozos
rebatos92913092rebatos
reboils94111722reboils
rebook125213202rebo_ok
rebooks134010512rebooks
reboot84119332rebo_ot
reboots93512092reboots
rebops10311432rebo_ps
rebores95319162rebores
baboos103517013babo_os
bebops1237623bebo_ps
bohos105618253__bohos
bolos75531373__bolos
boos67955033__bo_os
boyos105418283__boyos
bozo156821413__bozo_
ceboids1237653ceboids
debones103315113debones
ebons74316093_ebo_ns
ebook114510803_ebo_ok
ebooks12358333_ebooks
exodos1435943_exodos
kebobs14427293kebo_bs
mezzos1635043me_zzos
mozos165516333__mozos
preboils1267293preboils
prebook1557523prebo_ok
prebooks1656303prebooks
preboom1348243prebo_om
rabatos93010893rabatos
rebaits9312573rebaits
rebars84019823reb_ars
rebates95123173rebates
rebato83714683rebato_
rebbes10313533reb_bes
rebecks15288013rebecks
rebecs103913673reb_ecs
rebels84518133reb_els
rebids94015533reb_ids
rebills93510623rebills
rebinds104511873rebinds
rebloom1145653rebloom
reblooms1244283reblooms
reboant9315093reboant
reboard10310763reboard
reboards1138773reboards
rebodies1139163rebodies
rebody1238153rebo_dy
reboil83814683rebo_il
rebop9313283reb__op
rebore86625643rebo_re
rebored105015883rebored
reborn810016953rebo_rn
rebound1058583rebound
rebounds1156023rebounds
rebs65733563reb___s
rebuffs1533403rebuffs
rebukes134210553rebukes
rebus75721113reb__us
rebuses94915293rebuses
rebuts84015193reb_uts
rebuys11428783reb_uys
recoals94214623recoals
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolor978693recolor
recolors1078813recolors
recombs1336753recombs
recons84922993reco_ns
recook125513923reco_ok
recooks134711233recooks
records105213923records
recorks134813023recorks
recoups1188843recoups
rectos85718783re_ctos
redbones1137593redbones
redocks14409933redocks
redoes74623753redo_es
redons75222183redo_ns
redos65126763re__dos
redouts81411653redouts
redowas1138393redowas
redoxes15310883redoxes
refocus1236973refocus
refolds11298953refolds
reforms1239813reforms
regosol844883regosol
regosols944323regosols
rejoins143111383rejoins
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relook104813743relo_ok
relooks114010723relooks
remolds10299703remolds
remoras9314073remoras
remotes94521613remotes
removes124514713removes
renowns10277833renowns
reoils64516873re_oils
repolls939053repolls
reports94916213reports
repos74725793re__pos
reposes94021263reposes
repots85621003repo_ts
repours9310223repours
repros84216003re_pros
reredos838633reredos
rerolls739943rerolls
reroof9315003rero_of
reroofs1037943reroofs
resizes164216843resizes
resoaks1148973resoaks
resods74116303reso_ds
resoles73823653resoles
resorbs95010523resorbs
resorts74817193resorts
resows93915353reso_ws
retook104313443reto_ok
retool63914483reto_ol
retools73411023retools
retorts76016513retorts
retros63820193re_tros
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
rewords115413973rewords
reworks145113593reworks
rezeros1647453rezeros
rezones163213943rezones
rheboks1634003rhebo_ks
riboses9310443riboses
robalos937673robalos
robots8313143robo_ts
rococos1145903rococos
rotos56027883r__otos
rubatos9278643rubatos
rubigos1033643rubigos
ruboffs1543113ruboffs
rubouts937973rubouts
taboos83815423tabo_os
tremolos1046043tremolos

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.1731032896.0
2DLD Change Limit1340271477.31318327.2
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.53223724.2
 
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.