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

40 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
premolars134502(None) 
premolar1246631premolar_
premolds1345842premol_ds
areolar779223are_olar_
areolas71013863are_ola_s
exemplars2042143exemplars
molars85517323___molars
pedlars103210213p_e_dlars
pergolas1158233pergola_s
polars84419353p___olars
preboard1338263prebo_ard
preboards1446423prebo_ards
preclears1344373preclears
preloads1157513prelo_ads
premiers122911653prem_iers
premodern1444423premodern
premold1247863premol__d
premolded1544683premolded
premolt11312073premol__t
premoral1249713premora_l
premorse1237553premo__rse
preplans1249613pre_plans
presoaks1436603preso_aks
presolves1456533presolves
pretors9316803preto__rs
primulas1246123primula_s
prolans9314273pr__olans
promoters13310093promoters
recolors1078813_recolors
regulars936253_regulars
remolade1147203_remolade
remolades1246563_remolades
remolds10299703_remol_ds
remoras9314073_remora_s
removals1345643_removals
removers13449223_removers
templars1255263_templars
tremblers1334483tremblers
tremolos1046043tremol_os
tremors93711223tremo__rs

Search took 9 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.1531167915.0
2DLD Change Limit148641408.80016891.0
3Display Results40400.0133076.9
 (SQL Overall)178691408.96619929.8
 
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.