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

87 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
fruitions1210611(None) 
fruition11106101fruition_
eruditions1146102eruditions
eruptions1146762eruptions
fractions1449102fractions
frictions1448032frictions
fruiting12229062fruiti_ng
ructions102811682_ructions
tuitions838282_tuitions
abruptions1443843abruptions
additions1186333additions
ambitions1346343ambitions
arcuations1249343arcuations
auctions104012143_auctions
auditions1078753auditions
bruiting11259973bruiti_ng
cautions103313183cau_tions
coitions10312853_coitions
creations112614543creations
durations10311463durations
editions9310403_editions
eductions1268773eductions
elutions82513053elu_tions
equations1839493equations
erections112515213erections
erudition1046173erudition_
eruption1047043eruption_
factions133013063f_actions
ferritins1247273ferriti_ns
fetations12511383fetations
fictions132410743f_ictions
filiations13119093filiations
fixations1936353fixations
flections14239213flections
fluxions1844423flu_xions
foliations1399943foliations
formations1538203formations
fraction1359483fraction_
fractious1456143fractious
friction1347913friction_
frissons1145043fr_issons
frontons1136503front_ons
fructuous1442393fructuous
fruitages1344483fruitages
fruitarians1453733fruitarians
fruiters11328183fruit_ers
fruitier1136593fruiti_er
fruitiest1237383fruitiest
fruitily1445153fruiti_ly
fruitiness1345993fruitiness
fruitless1244163fruitless
fruitlets1243173fruitlets
fruits94512493fruit___s
fruitwood1652103fruitwood
fruitwoods1751993fruitwoods
functions1437743functions
furcations1547533furcations
fusions1039153f_u_sions
fustians1146403f_ustians
futons93911513f_u_t_ons
grunions945353gru_nions
ignitions1045803ignitions
intuitions1047293intuitions
irruptions1243893irruptions
lenitions939473lenitions
monitions11310883monitions
munitions1138173munitions
orations81515803or_ations
partitions1248333partitions
perditions1348873perditions
petitions11511083petitions
positions11811503positions
punitions1137923punitions
rations74123433_r_ations
ruction93611613_ruction_
ructious10277083_ructious
ruinations1039603_ruinations
rutins63818393_ru_ti_ns
seditions1039013seditions
sortitions1046433sortitions
suctions103012903_suctions
tractions11511623tractions
traditions1147203traditions
tritons73814883tr_it_ons
trunnions943003trunnions
tuition738823_tuition_
volitions1288663volitions

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.453394461.4
2DLD Change Limit148641876.79621871.8
3Display Results87870.0332636.4
 (SQL Overall)178691877.28224538.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.