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

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

91 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
disoriented135526(None) 
misoriented1453941misoriented
disorient10412522disorient__
disorientated1562362disorientated
disorients1177792disorient_s
discontented1655313discontented
disjointed1944833disjoi_nted
disordered1344323disorde_red
disorientate1363383disorientate
disorientates1462863disorientates
disorienting14155653disorienting
disquieted2144003disquie_ted
dissented1199723dis__sented
distributed15144753distributed
districted1448223distri_cted
misorient11510893misorient__
misorients1256003misorient_s
misprinted1545983mispri_nted
oriented937483___oriented
reoriented1145343_reoriented
deforested1543854defor_ested
diorite8314914di_ori__te_
diorites9313524di_ori__tes
directed1238234di__r_ected
disaffected21172554disaffected
disarranged1453404disarranged
disburdened1652444disburden_ed
discanted1339334dis__canted
discepted1547524dis__cepted
discommended2152344discommended
disconcerted1854344disconcerted
disconnected1853714disconnected
discounted1447844dis_counted
discredited1653604discredited
discreeter1344734discr_eeter
discrete11410284discr_e_te_
discriminated19154164discriminated
discrowned1744024discrown_ed
disdained1246024disdai_n_ed
disgruntled1451924disgr_untled
disherited1546704disheri__ted
disinfected1853674disinfected
disinfested1653724disinfested
disinter9310674dis__i_nter
disinvested1653474disinvested
disjected2086354dis__jected
disjoined1845834disjoi_n_ed
dislimned1344624dis_limn_ed
dismounted1445414dis_mounted
disobeyed1643464diso_be_yed
disorganized2452964disorganized
disowned1336434diso__wn_ed
dispended14147824dis__pended
dispensed13158774dis__pensed
dispirited1445934dis_pirited
displanted14126634dis_planted
disported13310304dispor___ted
disprized2247364dispri__zed
disrated10915574dis_r__ated
disrelated1247344dis_related
disrooted1147624dis_r_ooted
disrupted1345974dis_r_upted
disseated11711084dis__seated
dissected13108664dis__sected
dissenter1059134dis__senter
disserted11109814dis__serted
dissipated1446054dis_sipated
dissociated1555604dissoci_ated
distained1139604distai_n_ed
distended12157924dis__tended
distorted1139374distor___ted
distracted1448874distr_acted
distrained1257674distrain_ed
distressed1246444distr_essed
distribute13145524distribute_
distributee14124924distributee
distributes14135284distributes
distrusted1246294distr_usted
disunited1177274disuni__ted
divaricated1853494divaricated
imprinted1445754_impri_nted
miscreated1547424miscr_eated
misdirected1752464misdirected
misordered1443794misorde_red
misorienting15154964misorienting
mispainted1545014mispai_nted
mispointed1545574mispoi_nted
mistreated1348424mistr_eated
orienter838314___orienter
sprinted113411164__spri_nted
tormented1245964__tormented

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819918.81316886.3
3Display Results91910.0461978.3
 (SQL Overall)178691919.29519224.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.