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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

35 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
interinvolving216110(None) 
interinvolve18121383interinvolv__e
interinvolved20131203interinvolv_ed
interinvolves19131423interinvolv_es
interfolding1754584inter__folding
interknotting1852664interkn_otting
intermingling1763044intermin_gl_ing
reinvolving1852404__re_involving
interconverting21132595interconverting
intercropping2052805inter_cropping
intercrossing1653145inter_crossing
interfiling1546955inter__fil_ing
interflowing1953665inter_flo_wing
interiorising14144915interi_orising
interiorizing23144975interi_orizing
interjoining2054655inter__joining
interknitting1853285interkn_itting
interleaving1676165inter__leaving
interlining1249135interlin____ing
interlinking1755055interlin___king
interlocking1954905inter__locking
interlooping1554315inter__looping
interloping1446965inter__lo_ping
intermeddling1852565intermeddl_ing
internalising1455625inter_nalising
internalizing2356215inter_nalizing
interning10315255inter_n____ing
interpolating1657795inter__polating
interposing1447805inter__po_sing
intertilling1355375inter__tilling
intervening1548175inter__v_ening
interviewing1964245inter__viewing
interweaving1985165inter__weaving
interworking2054525inter__working
involving1644365_____involving

Search took 7 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 Filter178691950240.1231452772.4
2DLD Change Limit95024356.25015203.8
3Display Results35350.0331060.6
 (SQL Overall)178691356.40627894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.