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

67 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
diallages114546(None) 
diallage1045231diallage_
millages113212902mi_llages
pillages113012612pi_llages
smallages1245292smallages
tallages92312002_tallages
tillages93011262ti_llages
villages123010602vi_llages
alleges84212573__alleges
anlages82414113__anlages
ballades114211643_ballades
collages113514243_collages
dalles74222063d_all__es
dallies84023193d_all_ies
damages11511273d_a_mages
dealates92716683dea_lates
diabases1137223dia_bases
dialings10329823dialing_s
dialled9510133diall__ed
diallel845683diall__el
dialler848813diall__er
diallers957773diall_ers
diallings1134993diallings
diallists1056003diallists
dialoged1146693dia_loged
dialoger1056083dia_loger
dialogers1155163dia_logers
dialogs938103dia_log_s
dialogues1144813dialogues
dialysates1442943dialysates
dialyses1236133dia_lyses
dialyzates2342413dialyzates
dialyzes2144503dia_lyzes
diastases1047073diastases
dilates83220663di__lates
dillies84122163di_ll_ies
dislodges1245163dislodges
displaces1448593displaces
divulges1343603divul_ges
drainages1145503drainages
drayages1344503dra_yages
gallates92815523_gallates
grillages1174943grillages
haulages1236623_haulages
haylages1536013_haylages
hypallages1951813hypallages
milages103114403mi__lages
mileages11249693mi_leages
millage103112753mi_llage_
pillage103412603pi_llage_
pillaged12298093pi_llaged
pillager11278553pi_llager
pillagers12276923pi_llagers
salvages1238123_salvages
scalages113010253sca_lages
silages82514443si__lages
smallage1145183smallage_
spillages1256083spillages
sullages939973_sullages
tallage82712073_tallage_
tallaged10257923_tallaged
tillage83111343ti_llage_
tollages92410193_tollages
ullages838953__ullages
village113610833vi_llage_
villager12267513vi_llager
villagers13296153vi_llagers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641677.26620457.1
3Display Results67670.0164187.5
 (SQL Overall)178691677.70223200.6
 
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.