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

154 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
orienter83831(None) 
oriented937481oriented
orienteer943211orienteer
orienters937631orienters
orient6322532orient__
oriental848492oriental
orienteers1042692orienteers
orients7311582orient_s
printer93917302pri_nter
reenter73217792_reenter
reinter73116842_reinter
renter64527412_r_enter
tormenter1146702tormenter
trientes82812132trientes
absenter1086773absenter
aliener71011193alien_er
ancienter1145393ancienter
ariette7312373ariette_
ariettes8411353ariettes
arrester839253arrester
assenter867713assenter
briefer1235563brie_fer
brighter1476663brighter
briner84519043bri_n_er
bringer104213353bri_nger
brinier93613473bri_nier
carpenter1346513carpenter
cementer1239193cementer
center84421413__center
cointer93616723coi_nter
commenter151410693commenter
concenter13312213concenter
consenter11312493consenter
coriander1245663coriander
correcter1348113correcter
cringer103514243cri_nger
critter94113033cri_tter
decenter112412163decenter
diester83013683_diester
dieter73516773_die_ter
directer1137583directer
drifter11348703dri_fter
drinker12349483dri_nker
enter54726383___enter
epicenter1395503epicenter
erecter93113393er_ecter
fainter103611053fai_nter
fermenter1497543fermenter
fomenter1339263fomenter
forester11313673for_ester
forfeiter1544173forfeiter
forgetter1345373forgetter
fretter103412753fr_etter
friended1335033friended
fritter103912773fri_tter
fronter103611583fr_onter
granter84117133gr_anter
greater84416493gr_eater
greener83111713green_er
greenier938713greenier
greeter82812673gr_eeter
griever1136033grie_ver
grifter113810493gri_fter
grinder93312393gri_nder
grinner8329233gri_nner
grister83915413gri_ster
gritter83913353gri_tter
grunter83110783gr_unter
hinter94021303_hi_nter
incenter102212093incenter
indenter92311443indenter
inter55028493__i_nter
inventer112410843inventer
jointer14379713joi_nter
kiester11329973_kiester
lamenter1038863lamenter
lientery1134883_lientery
linter64625343_li_nter
loriner7511893lori_n_er
minter84425103_mi_nter
misenter10310833misenter
offender1543723offender
oftener1035923often_er
omitter9298503omi_tter
opener83910993o_pen_er
orbiter937853or_biter
orderer8127943orde_rer
orientals946923orientals
orientate946513orientate
orientated1144853orientated
orientates1046043orientates
orienting1038723orienting
ornerier846043ornerier
orometer10310703orometer
oximeter1755153oximeter
painter93814563pai_nter
patienter1145563patienter
pointer93814933poi_nter
preener93114833preen_er
presenter11311643presenter
prester93519623pr_ester
preventer1438593preventer
priested1138393priested
prinker133412743pri_nker
printed104016373pri_nted
printers103214913pri_nters
printery13318433pri_ntery
privater13158533privater
quieter162810333quie_ter
ranter63826823_r_anter
recenter102715443recenter
reenters82915313_reenters
reinters82614773_reinters
render74024143_r_ender
rente54733783_r_ente_
rented74426593_r_ented
renters74224823_r_enters
rentes65431193_r_entes
rentier73618223_r_entier
reoriented1145343reoriented
repenter102813863repenter
rester63832433_r_ester
riever94811653_rie_ver
righter113212383_righter
rimester1037813_rimester
ringer74526063_ri_nger
rinser64317213_ri_nser
rioter64817283_ri_oter
ripener937913_ripen_er
ritter63822423_ri_tter
riveter10208753_riveter
roister73516203roi_ster
silenter838873silenter
sinter63625923_si_nter
sprinter103810813spri_nter
stinter73614513sti_nter
tenter64623933__tenter
tinter63923643_ti_nter
tormented1245963tormented
tormenters1245833tormenters
tormentor1144363tormentor
treater74219833tr_eater
triene64316383trien_e_
trienes74118413trien_es
trimester1145823trimester
trimeter10310083trimeter
triter65120593tri__ter
ureter6313203ur_e_ter
venter94218723__venter
wiener94513543_wien_er
winter94222803_wi_nter
wrester102812413wr_ester
wringer113612453wri_nger
writer94416513wri__ter

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621546.61022112.3
3Display Results1541540.0463347.8
 (SQL Overall)1786911547.07925242.4
 
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.