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

92 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
rodeo6592109(None) 
roadeo7510321roadeo
rode55844301rode_
rodeos75314501rodeos
rodes614039081rodes
romeo73719701romeo
bode75838752bode_
boded95124962boded
bodes84935102bodes
code77347732code_
codec107120342codec
coded95433182coded
coden86128542coden
coder86134212coder
codes86247292codes
codex155817572codex
dodo66024912dod_o
erode64520992erode_
eroded84313582eroded
erodes74819882erodes
godet7530042godet
lode56240112lode_
loden66621142loden
lodes66436912lodes
mode75840302mode_
model84521692model
modem103717142modem
modes85537412modes
node513036882node_
nodes64633492nodes
ode47446582_ode_
odea56224572_odea
odeon6411482_odeon
odes57243242_odes
oleo46630482_oleo
order65019362order
ordo54622352ord_o
radio64922492radio
rede55037662rede_
reded74829112reded
redes65139122redes
redo56029362red_o
ride55945122ride_
rider65231302rider
rides66140812rides
roadeos837402roadeos
robe65335642robe_
robed85323732robed
robes75133302robes
rod47953892rod__
rodded93713702rodded
rodent7519242rodent
rodeoed937882rodeoed
rodmen939712rodmen
rods56442062rod_s
roe36861072ro_e_
roes45954132ro_es
roger64521412roger
role45851822role_
roles56747982roles
romeos84013172romeos
rondel73212642rondel
rondo65218372rondo
rope65542912rope_
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rose46148902rose_
rosed65930342rosed
roses56445772roses
roset55945242roset
rote46249022rote_
rotes56143902rotes
roto45935052ro_to
roue45941742roue_
rouen54920902rouen
roues56039352roues
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
roves84834482roves
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rower85430492rower
rude55632782rude_
ruder65320542ruder
trode65322852trode_
video96014952video
yodel94714082yodel

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 Filter178691538000.0802233637.5
2DLD Change Limit53800921.73331044.4
3Display Results92920.0303066.7
 (SQL Overall)178691921.84396956.6
 
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.