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

157 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
reflected154798(None) 
deflected1635981deflected
reelected1238311reelected
refected142311661ref_ected
beflecked2142652beflecked
defected15289972def_ected
effected1744992_effected
elected102812612_e_lected
inflected1546052inflected
neglected1354692neglected
preelected1545782preelected
prelected1439132pre_lected
reejected1955092reejected
reerected1238612reerected
reflated123514292refl_ated
reflect123913712reflect__
reflector1445732reflector
reflects13288872reflect_s
reflexed1975252refle_xed
refloated1347012refloated
refracted1557392refracted
rejected182710112re_jected
relented92614942re_lented
relucted1138652re_lucted
resected112514742re_sected
reselected1345632reselected
respected1438492respected
selected1159782se_lected
affected1744793_affected
afflicted1843433afflicted
befleaed1454663befle_aed
befretted1544373befretted
collected1447973collected
defeated132812163def_eated
defecated1637493def_ecated
deflated133412303defl_ated
defleaed1344953defle_aed
deflect13399973deflect__
deflector1555063deflector
deflects14336733deflect_s
deflexed2043883defle_xed
dejected19307593de_jected
deleted93314913de_le_ted
depleted12258723deple_ted
deselected1444083deselected
detected12289733de_tected
effecter1664773_effecter
ejected17297653_e_jected
electee92513243_e_lectee
erected103213993_e_rected
expected2036743_expected
exsected1835673_exsected
flecked17358073__flecked
fleeted113310233__fleeted
genuflected1851143genuflected
infected14229403inf_ected
inflicted1545533inflicted
leafleted1342893leafle_ted
leafletted1441973leafletted
neglecter1263633neglecter
pelleted1138203pelle_ted
perfected1736643perfected
praelected1544393praelected
preerected1545573preerected
preselected1643963preselected
reacted103015713re__acted
reblended1355203reblended
rechecked2143973rechecked
recleaned1236583recleaned
recollected1643853recollected
recreated12412533recreated
redacted12410243re_dacted
redefected1743853redefected
redirected1444773redirected
rednecked1743163rednecked
reelect911515633reelect__
reelects103110883reelect_s
reelevated1445153reelevated
reenacted1236853reenacted
reested82916233re__ested
reexecuted2062693reexecuted
refaced133713573ref_ac_ed
refect114319333ref_ect__
refects124012743ref_ect_s
refeed104717623ref_e__ed
refelled122810163ref_elled
refenced1438993ref_enced
refereed12149693ref_ereed
referred1297833ref_erred
refitted12309413ref_itted
reflagged1543093reflagged
reflate103516263refl_ate_
reflates113115663refl_ates
reflecting1638823reflecting
reflection15168993reflection
reflective1857123reflective
reflectors1545503reflectors
reflet94024233refle_t__
reflets103513153refle_t_s
reflexes1865933refle_xes
reflooded1443553reflooded
reflowed15126903refl_owed
refluxed1954353refl_uxed
reforested1445383reforested
refreshed1685613refreshed
refronted1336053refronted
refueled1286573refue_led
refuelled1364503refuelled
refuted114313803ref__uted
regelated1139723regelated
regreeted1136173regreeted
regretted1137233regretted
reheated122415003re_heated
reinfected1645253reinfected
reinjected2044443reinjected
rejectee17289623re_jectee
rejecter17258943re_jecter
relaced103517213re_lac_ed
related83327573re_l_ated
released9310243re_leased
relegated1139763re_legated
reletter81311023re_letter
relisted9312623re_listed
relocated12710813re_located
relocked15217743re_locked
remelted11310153re_melted
renested92212953re_nested
reobjected2242253reobjected
repeated113117443re_peated
repented112614983re_pented
replaced133211403replac_ed
replanted1248063replanted
replated112817523repl_ated
repleaded1336293repleaded
repledged1443633repledged
replete92912993reple_te_
repletes102812473reple_tes
replevied1574373replevied
replicated1548773replicated
replotted1235823replotted
requested1935893requested
rerented92516163re_rented
reseated93220263re_seated
resented92716963re_sented
reslated93517523resl_ated
resmelted1236033resmelted
respecter1347443respecter
retested92212533re_tested
retracted12410953retracted
retreated10312623retreated
reverted122714713re_verted
revested122612243re_vested
revetted122210943re_vetted
rewetted12228353re_wetted
rouletted1045053rouletted
selectee10910493se_lectee
unelected1237823unelected

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411577.98318619.7
3Display Results1571570.0801962.5
 (SQL Overall)1786911578.48621057.2
 
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.