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

38 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
maxillipeds23583(None) 
maxilliped2251551maxilliped_
millipeds1444702m__illipeds
millepeds1443223m__illepeds
milliped1337383m__illiped_
millipede1444223m__illipede
millipedes1543713m__illipedes
alipeds10386794_a___lipeds
callipees1345304ca__llipees
callipers1356494ca__llipers
filliped1435224__filliped_
mailless10248584ma_ill__ess
mainlined1254354ma_inlined_
mainliners1244004ma_inliners
mainlines1138514ma_inline_s
manilles102312604manill__e_s
maxillae17256724maxill_ae__
maxillaries2053104maxillaries
maxillas17227704maxill___as
maximised2143574maxi_mised_
maximises2044874maxi_mise_s
maximites2045314maxi_mite_s
maximized3043984maxi_mized_
maximizers3042394maxi_mizers
maximizes2944404maxi_mize_s
milleped1335174m__illeped_
millepede1442984m__illepede
millepedes1552734m__illepedes
milliards1246194m__illiards
milliers102611904m__illi_ers
millimes122411374m__illime_s
milliners11289954m__illiners
millines102718064m__illine_s
millirems1344324m__illirems
multipeds1445664m__ultipeds
ramillies1146134ramilli_e_s
tailpipes1373074ta_ilpipe_s
talipeds1183554ta___lipeds

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 Limit148819388.69017125.3
3Display Results38380.0132923.1
 (SQL Overall)178691389.10919617.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.