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

130 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
reorient861347(None) 
reorients997361reorients
orient6322532__orient
reoriented1145342reoriented
reprint9318982repri_nt
rerent63832452re_r_ent
aeriest73924053ae_riest
aperient10715153aperient
beeriest104013403beeriest
befriend1443263befriend
detriment1249693detriment
disorient10412523disorient
dormient1148453_dormient
dreariest10229123dreariest
eeriest73620673_eeriest
eobiont959943_eobiont
erodent8313823ero_dent
esurient849293esurient
ferment12315573fe_rment
fervent13310063fe_rvent
forint9325023_fori_nt
fornent10312933_fornent
forwent13310533_forwent
gerent73223103ge_r_ent
goriest82218743_goriest
horrent10313553_horrent
leariest83117853leariest
leeriest83112883leeriest
lenient7313843le_nient
merriest10311483merriest
merriment1358033merriment
misorient11510893misorient
mooriest102812723mooriest
mordent10313993_mordent
nescient1048713nescient
nutrient848353nutrient
orients7311583__orients
percent113520603pe_rcent
perpent112318813pe_rpent
portent93619643_portent
preprint12314183prepri_nt
prescient13411323prescient
prurient1048233prurient
quotient1746413quotient
reaccent1278573reaccent
readiest93719043readiest
reagent8716603re_agent
rearing83128783reari_ng
rearrest8311603rearrest
reascent10411983reascent
reblent9614253re_blent
reboring11312783rebori_ng
recement12315653recement
recent83630853re__cent
recipient1348023recipient
recreant10311283recreant
recrement13411363recrement
recurrent1146713recurrent
redirect11147993redirect
redolent9411883redolent
redried93714903redrie_d
redries83721713redrie_s
redriven12226153redriven_
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
reerect92915883reer_ect
referent112813423referent
refluent1147433refluent
reforest1139963refor_est
refried113513883refrie_d
refries104419733refrie_s
refront10313263refr_ont
regent74127673re__gent
regiment114414053regiment
regrant8317323regr_ant
regreen8309043regreen_
regreens9257453regreens
regreet83015953regr_eet
regret73723533regr_e_t
regrind938983regri_nd
reinvent1138903reinvent
relent64431853re__lent
reliant7319243re_liant
relucent1049283relucent
remanent10311703remanent
remint85329983re_mi_nt
renitent8315333renitent
reobject1953113reobject
reopen8311573reo_pen_
reopens939373reo_pens
reorder8239483reorde_r
reorders9198833reorders
reorientate1153373reorientate
reorienting1246353reorienting
repaint9318363repai_nt
repent84728873re__pent
represent11410073represent
reprieve1375443reprieve
reprints1039903repri_nts
rerents73319423re_r_ents
rerisen73613643re_risen_
resent63833623re__sent
resident9313753resident
resilient9410113resilient
resolvent1246583resolvent
resurgent1047953resurgent
reticent10313293reticent
retint65633443re_ti_nt
retirant8313593retirant
retreat7317533retr_eat
retried84419163retrie_d
retries74129073retrie_s
retrieve1175693retrieve
revehent14239083revehent
reverent112615093reverent
rodent7519243r_o_dent
rookiest122912173rookiest
roomiest102611993roomiest
rootiest83115593rootiest
ropiest93317773r_opiest
rosiest73919213r_osiest
sentient8313633sentient
serpent92916283se_rpent
sorbent92915243_sorbent
teariest82417263teariest
torment9316173_torment
torrent7313413_torrent
veriest103719133ve_riest
weariest112914793weariest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621308.32617554.9
3Display Results1301300.0502600.0
 (SQL Overall)1786911308.79920308.1
 
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.