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

32 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
multiphasic205302(None) 
multiphase1744652multiphas_e
multichain1754033multicha_in
aliphatic1645344_al_iphatic
biphasic1744184___biphasic
diphasic1645804___diphasic
metaphysic2253974m_etaphysic
multidisc1444014multi_dis_c
multiethnic1861874multiethnic
multiflash1852924multiflas_h
multigenic1554454multi_genic
multigrain1354114multigra_in
multiorgasmic207794multiorgasmic
multipack1944644multip_a_ck
multipacks2054134multip_acks
multipage1446454multip_a_ge
multipaned15105964multip_aned
multipara1345994multip_a_ra
multiparae1445664multip_arae
multiparas1445404multip_aras
multipart1347514multip_a_rt
multiparty1754804multip_arty
multipath1646054multip_a_th
multipeds1445664multipeds__
multiphoton1852724multiphoton
multiplant1456424multipla_nt
multiplayer1854224multiplayer
multiples13118124multiples__
multitask1564034multi_tas_k
multitasks1663234multi_tasks
polyphasic2254134pol_yphasic
ultrabasic1453324_ultrabasic

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.406440125.6
2DLD Change Limit148819329.31315979.7
3Display Results32320.0162000.0
 (SQL Overall)178691329.73518355.5
 
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.