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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
immigrational185193(None) 
immigration1644172immigration__
immigrations1743722immigration_s
migrational1444742__migrational
immigrating1743313immigrati_n_g
antirational1278494anti_rational
arbitrational1553184arbitrational
aspirational1455004aspi_rational
emigration13228214_emigration__
emigrations14187154_emigration_s
imbibitional1861704imbi_bitional
indicational1545754indi_cational
inspirational1554414inspirational
invitational1554904invi_tational
irrational1047214___irrational
librational1344554__librational
limitational1453544limi_tational
maturational1454184_maturational
migration12179704__migration__
migrations13168684__migration_s
navigational1653294navig_ational
remigration14228914remigration__
remigrations15227794remigration_s
vibrational1644364__vibrational
aberrational1453485_aberrational
admiration1347735admi_ration__
admirations1446695admi_ration_s
agitational1244845_agi_tational
antinational1297485anti_national
binational1246375__bi_national
citational1266465__ci_tational
combinational1984085combinational
computational1994575computational
configurational2162205configurational
denigration1348465denigration__
denigrations1447355denigration_s
derivational1654265deri_vational
emigrating1467505_emigrati_n_g
examinational2252185exami_national
explorational2252555explorational
fumigation1645625fumig_ation__
fumigations1744925fumig_ation_s
generational1354825_generational
gyrational1444745___gyrational
hyperrational2153935hyperrational
ideational1146505___ideational
illustrational1461555illustrational
imagination1447195imagination__
imaginations1546345imagination_s
imitation11510855i_mi_tation__
imitations1259965i_mi_tation_s
immigrant1453195immigra___n_t
immigrants1552075immigra___nts
immigrate1444355immigrat____e
immigrated1643315immigrat___ed
immigrates1544025immigrat___es
immoderation1753435immoderation__
immoderations1853075immoderation_s
immolation1446105imm_olation__
immolations1545475imm_olation_s
impetration1545905impetration__
impetrations1645445impetration_s
incantational1553565incantational
inclinational1553935inclinational
indignation1346535indignation__
indignations1446045indignation_s
informational1854345informational
inhalational1553045i_nhalational
innovational1553835i_nnovational
insertional1147465i_nser_tional
integration121310495integration__
integrations13129475integration_s
interactional1557005i_nteractional
international1357675international
intonational1256005i_ntonational
invigoration1654595invigoration__
invigorations1753915invigoration_s
invitationals1652745invi_tationals
invocational1754415i_nvocational
irrationals1154735___irrationals
irrigation1147805irrig_ation__
irrigations1246945irrig_ation_s
irrotational1254025i_rrotational
levitational1553635levi_tational
mediational1445645__mediational
microtonal1456145__microt_onal
migrating13910535__migrati_n_g
mitigation1348645mitig_ation__
mitigations1447625mitig_ation_s
motivational1753915_motivational
mutational1246515__m_utational
narrational1145445__narrational
negational1147155__neg_ational
nonrational11109125__nonrational
operational1347525__operational
oscillational1552235oscillational
perorational1446395_perorational
premigration1755695premigration__
radiational1245965radi__ational
rational8412545_____rational
remigrating1547595remigrati_n_g
situational1144585__situational
subrational1345495__subrational
summational1553685sum__mational
suprarational1552925suprarational
terminational1553485termi_national
ultrarational1363515ultrarational
variational1444785vari__ational

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901088.12315362.6
3Display Results1081080.0631714.3
 (SQL Overall)1786911088.57620836.2
 
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.