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

149 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
redbird115526(None) 
redbirds1283871redbirds
reedbird1273261reedbird
rebid85121362re_bi_d
rebind94416932re_bind
redbud10135802redb_ud
redid74922392red_i_d
redried93714902redried
reedbirds1362482reedbirds
seabird1055362seabird
bedboard14115723bedboard
bedrid1039943bedri_d
bedward1497473bedward
begird1036823be_gird
bellbird1343823bellbird
bird76128333___bird
boobird1235233boobird
catbird1235243catbird
cebid104314083ce_bi_d
cedarbird1571423cedarbird
cowbird1534433cowbird
eddied9248323_eddied
engird8126973_engird
fatbird1344033fatbird
firebird1444633fire_bird
jaybird2043123jaybird
ladybird1542153ladybird
lyrebird1442093lyre_bird
maybird1543993maybird
mediad104313713med_iad
oilbird1043743oilbird
ovenbird1442613ovenbird
prebid113512843pre_bi_d
prebind123810643pre_bind
predried12309573predried
rabid84520783r_abi_d
railbird1143443railbird
rainbird1143143rainbird
readied93316623readied
rebar75420193re_bar_
rebars84019833re_bars
rebids94015533re_bids
rebill84713253re_bill
rebinds104511873re_binds
rebirth1244933re_birth
reboard10310763reboard
rebore86625653re_bore
rebored105015883re_bored
reborn810016963re_born
rebred95816353re_bred
rebuild1036293rebuild
rebury11349213re_bury
record96117433re_cord
redated93120923redated
redbait1039803redbait
redbaited1344713redbaited
redbaits1135903redbaits
redbay1238333redb_ay
redbays1336013redbays
redbone1037973redbone
redbrick1742653redbrick
redbuds11144283redbuds
redbug10165473redb_ug
redbugs11134463redbugs
redd66323183red___d
redded94019553red_ded
redder83918143redder_
redders93615343redders
redding103218513redding
reddish1238033reddish
reddled102912323reddled
redear73515173redear_
redears82814453redears
reded74829123red__ed
redefied1368223redefied
redenied10511283redenied
redfin10310223redfi_n
redfins1139923redfins
redfish1437793redfish
redhead1257053redhead
redia65524483red_i_a
rediae74221993red_iae
redial74923113red_ial
redias74523613red_ias
reding83825563red_ing
redip87816963red_i_p
redips93713843red_ips
redipt94116743red_ipt
redline84218833redline
redlined103811233redlined
redoing93516733redoing
redound968173redound
redries83721713redries
redrill857893redrill
redrive112410563redrive
redry94314363red__ry
redshirt1245853redshirt
redubbed1433143redubbed
reduced11610323reduced
reduviid1342293reduviid
redware1139363redware
redwing122811983redwing
redwood1236523redwood
redyed114611243red_yed
refind104717073re_find
refire95419473re_fire
refired115116993re_fired
refried113513883refried
regard85215773re_gard
regild8149773re_gild
regrind938983regrind
reheard11309023reheard
rehire95415863re_hire
rehired115013153re_hired
reified112913783reified
relaid75518443relai_d
relied74926233re_lied
remind94819793re_mind
remorid10311863remorid
repaid94716323repai_d
repair84011463repair_
repaired1148953repaired
repairs9319973repairs
replied103914463replied
require16148653require
required18156833required
resaid74517083resai_d
rescind10410393rescind
resid64124093re_si_d
respire9411543respire
respired1148993respired
retard75018933re_tard
retied75924983re_tied
retire64927013re_tire
retired84620143re_tired
retried84419163retried
reward106017643re_ward
rewind104715883re_wind
rewire95421413re_wire
rewired115413283re_wired
reword106321413re_word
reynard1135123reynard
ricebird1343003ricebird
rubied94312413r_ubied
seabirds1164403seabirds
sunbird1044743sunbird
verbid122311313verbi_d
weird95111283we__ird
yardbird1542323yardbird

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.406440125.6
2DLD Change Limit1340271496.84319586.0
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.29524495.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.