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

48 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
realignments155329(None) 
realignment1453911realignment_
alignments1344632__alignments
reassignments1662112reassignments
alignment1246373__alignment_
arraignments1553163arra_ignments
designments1545123de_signments
misalignments1862173misalignments
nonalignments1662963nonalignments
rearguments1483843rea_rguments
reassignment1552673reassignment_
repigments1546343re_pig_ments
alightments1792764__alightments
aliments10311094__ali__ments
alinements1247134__alinements
arraignment1453614arra_ignment_
assignments1453324_assignments
belligerents1562514belligerents
consignments1753934consignments
designment1446054de_signment_
detainments1485894detai_nments
eloinments1245994_e_loinments
enlistments1345664_enlistments
ligaments1246204___ligaments
misalignment1762664misalignment_
nonalignment1563524nonalignment_
ordainments1453544orda_i_nments
raiments1039904r_a_i__ments
ravagements1754164r_avagements
ravishments1954104r_avishments
reagents959624rea__g__ents
realigned1145334realign_e__d
realigning1245934realign_in_g
realigns936254realig___n_s
reargument1374664rea_rgument_
rearmaments1554264rea_rmaments
reenlistments1582794reenlistments
refinements1646794re_finements
refrainments1754004refrainments
regiments123910324re___giments
reinvents1246124re__i_nvents
remitments1446844re_mi_tments
repigment1447924re_pig_ment_
replacements1854444replacements
requirements2384044requirements
rescindments1752794rescindments
retirements1357614re_tirements
revilements1647134re_vilements

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 Filter1786911247900.390458182.1
2DLD Change Limit124790486.75018487.4
3Display Results48480.0301600.0
 (SQL Overall)178691487.17024922.0
 
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.