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 “reorients” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
reorients99736(None) 
reorient8613471reorient_
orients7311582__orients
reoriented1145342reoriented
reprints1039902repri_nts
rerents73319422re_r_ents
aperients1178253aperients
befriends1542413befriends
detriments1347363detriments
disorients1177793disorients
eobionts1043983_eobionts
ferments13311473fe_rments
forints10411833_fori_nts
gerents82612923ge_r_ents
merriments1446323merriments
misorients1256003misorients
mordents1138813_mordents
nescients1145103nescients
nutrients944423nutrients
orient6322533__orient_
percents122713373pe_rcents
perpents122312043pe_rpents
portents103512823_portents
preprints1347473prepri_nts
quotients1843023quotients
reaccents1365853reaccents
reagents959623re_agents
rearrests945313rearrests
reascents1177403reascents
recements13312283recements
recipients1444893recipients
recreants1146623recreants
recrements1449353recrements
redirects12125103redirects
redries83721713redrie__s
reerects10319923reer_ects
referents12259643referents
reforests1245533refor_ests
refries104419733refrie__s
refronts1137773refr_onts
regents83416543re__gents
regiments123910323regiments
regrants9310013regr_ants
regreens9257453regreen_s
regreets9287853regr_eets
regrets83212923regr_e_ts
regrinds1035533regri_nds
reinvents1246123reinvents
relents74018503re__lents
remints95117293re_mi_nts
reobjects2062003reobjects
reopens939373reo_pen_s
reorders9198833reorde_rs
reorientate1153373reorientate
reorientates1253103reorientates
reorienting1246353reorienting
repaints1038483repai_nts
repents93717623re__pents
represents1246753represents
reprieves1475113reprieves
reprint9318983repri_nt_
rerent63832453re_r_ent_
resents74221223re__sents
residents1038423residents
resolvents1344343resolvents
retints74717013re_ti_nts
retirants947323retirants
retreats8311413retr_eats
retries74129073retrie__s
retrieves1265653retrieves
rodents8611543r_o_dents
sentients948463sentients
serpents102410373se_rpents
sorbents10279133_sorbents
torments10310453_torments
torrents838143_torrents

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 Limit148641768.07618405.3
3Display Results76760.0332303.0
 (SQL Overall)178691768.53220943.6
 
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.