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

37 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
disorient1041252(None) 
disorients1177791disorients
misorient11510891misorient
disoriented1355262disoriented
misorients1256002misorients
absorbent1345033absorbent
adsorbent1243883adsorbent
diriment11410743di__riment
disbarment1546653disbarment
discontent13410253discontent
discordant1445423discordant
discreet11413183discr_eet
dishiest12313683dis_hiest
disjoint1649233disjoi_nt
disobedient1553363disobedient
disorder1038133disorde_r
disorders1146963disorders
disorientate1363383disorientate
disorienting14155653disorienting
disownment16115833disownment
disportment1656653disportment
disquiet1879923disquie_t
dissent84018683dis__sent
dissident1147693dissident
dissolvent1454573dissolvent
distent84120853dis__tent
distraint101112903distraint
district11413873distri_ct
divergent1447363divergent
dormient1148453d__ormient
esurient849293_esurient
misoriented1453943misoriented
misprint12912973mispri_nt
orient6322533___orient
reorient8613473_reorient
sorbent92915243__sorbent
visoring1238373visori_ng

Search took 7 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 Limit148641376.28023668.9
3Display Results37370.0162312.5
 (SQL Overall)178691376.71926594.9
 
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.