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

52 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
realignment145391(None) 
realignments1553291realignments
alignment1246372__alignment
reassignment1552672reassignment
alignments1344633__alignments
arraignment1453613arra_ignment
designment1446053de_signment
misalignment1762663misalignment
nonalignment1563523nonalignment
realigned1145333realign_e_d
realigning1245933realign_ing
reargument1374663rea_rgument
reassignments1662113reassignments
repigment1447923re_pig_ment
alightment1693954__alightment
aliment9316704__ali__ment
alinement1149104__alinement
arraignments1553174arra_ignments
assignment1353894_assignment
belligerent1453744belligerent
consignment1654614consignment
designments1545124de_signments
detainment1377144detai_nment
eloinment1147254_e_loinment
enlistment1246854_enlistment
ligament1149314___ligament
malignant1245224_malign_ant
misalignments1862174misalignments
negligent1144194neglig__ent
nonalignments1662964nonalignments
ordainment1354144orda_i_nment
premalignant1761554premalign_ant
raiment9315414r_a_i__ment
ravagement1644984r_avagement
ravishment1855124r_avishment
reagent8716604rea__g__ent
realign838764realig___n_
realigns936254realig___ns
rearguments1483844rea_rguments
rearmament1455384rea_rmament
reenlistment1463364reenlistment
refinement1548194re_finement
refrainment1654484refrainment
regiment114414054re___giment
reinvent1138904re__i_nvent
remitment1349444re_mi_tment
repigments1546344re_pig_ments
replacement1755204replacement
requirement2284494requirement
rescindment1653594rescindment
retirement1259124re_tirement
revilement1548484re_vilement

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.423422437.4
2DLD Change Limit148819528.93616653.9
3Display Results52520.0331575.8
 (SQL Overall)178691529.39219025.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.