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

83 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
latticing124606(None) 
latticings1342841latticings
attiring939482_attiring
bratticing1543922bratticing
anticking1649243_anticking
anticling12310693_anticling
antiking13412063_antiking
articling1247713_articling
attaching1545433_attaching
attacking1635323_attacking
attaining1047213_attaining
atticism1268533_atticism
atticist10811343_atticist
atticize1948443_atticize
atticizing2246313_atticizing
attriting1048683_attriting
attuning935903_attuning
baptising1446093baptising
baptizing2345833baptizing
batiking1537503ba_tiking
battening12268853battening
battering122715143battering
batting104422273batt__ing
battling113110493batt_ling
blattering13108713blattering
blatting114111653blatt__ing
catfacing1744553catfacing
catting103922643catt__ing
clattering13109233clattering
enticing11311803_enticing
fattening13287833fattening
fatting113818703fatt__ing
flatlining1443813flatlining
flattening14115103flattening
flattering1498743flattering
flatting123511253flatt__ing
hatting113920233hatt__ing
lacing94626233la___cing
lactating1239183lactating
laicising1245623laicising
laicizing2145713laicizing
lairing83715343la__iring
lancing103314123la__ncing
lasting84725243last__ing
latching143712023la_tching
latening9711493la_tening
laterizing2049083laterizing
lathering13912253lathering
lathing114315693la_t_hing
latinizing2048113latinizing
lattice938433lattic__e
latticed1134793lattic_ed
lattices1038383lattic_es
lattin64316223latt__in_
lattins74115483latt__ins
lawgiving1762143lawgiving
lettering102112073lettering
letting83218533lett__ing
littering102411973littering
lotting82917753lott__ing
mattering122314053mattering
matting103620143matt__ing
morticing1448013morticing
nattering102212203nattering
noticing1139453_noticing
patining11312303pa_tining
pattering122314423pattering
patting103722343patt__ing
plasticine1496113plasticine
platting114813033platt__ing
practicing1775583practicing
rattening10288763rattening
ratting83822363ratt__ing
rattling92510873ratt_ling
slatting94014233slatt__ing
tattering102212323tattering
tatting84019523tatt__ing
tattling9259463tatt_ling
tattooing1043963tattooing
tricing103417353__tricing
vatting113614853vatt__ing
wattling12258783watt_ling
yattering132410443yattering

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 Filter1786911486410.200893455.0
2DLD Change Limit148641838.89316714.4
3Display Results83830.0302766.7
 (SQL Overall)178691839.12319586.9
 
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.