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

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

65 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
preinterviewing2471141preinterviewing_
reinterviewing2161392_reinterviewing_
interviewing1964244___interviewing_
preinterview2062024preinterview____
preinterviewed2371104preinterview__ed
preinterviews2161324preinterview___s
reinterpreting1762325_reinterpreting_
reinterview1752655_reinterview____
reinterviewed2071515_reinterview__ed
reinterviews1851615_reinterview___s
intervening1548176___interv_ening_
predetermining2061756predetermi_ning_
preinserting1544176preinser___ting_
preinviting1744366prein___vi_ting_
pretermitting1852556pre__termitting_
previewing1943676pr____e_viewing_
reinnervating1752926_reinnerv_ating_
reinterring1245366_reinter___ring_
rereviewing1852216_re__re_viewing_
interceding1568047___inter_ceding_
interdicting1647457___interdicting_
interfering1558927___inter_fering_
interfiling1546957___interfi_ling_
interflowing1953667___interflowing_
interlining1249137___interli_ning_
interlinings1355067___interli_nings
interlinking1755057___interlinking_
intermitting1547257___intermitting_
intermixing2146617___intermi_xing_
interpreting1588307___interpreting_
intertilling1355377___intertilling_
interview1547367___interview____
interviewed1844147___interview__ed
interviewee1754017___interview__ee
interviewees1853117___interview_ees
interviewer1754037___interview__er
interviewers1853227___interview_ers
interviews1645267___interview___s
misinterpreting2071367misinterpreting_
orienteering1352617oriente___ering_
orienteerings1461597oriente___erings
prealtering1446177prealter____ing_
preinforming2072697preinfor___ming_
prenticing1547887pre_nt___i_cing_
preserving1637367pre__serv___ing_
presterilizing26122757pre_sterilizing_
presurveying2151357pre__surv_eying_
pretensioning1662807pre__tensioning_
pretraining1446507pre__t_rai_ning_
pretrimming1843037pre__t_r_imming_
printeries12410637pr_inter_ie____s
redetermining1752317_redetermi_ning_
reenergizing2352517_reen_ergi_zing_
reentering1149987_reenter____ing_
reinserting1256907_reinser___ting_
reintegrating1554617_reinte_grating_
reintroducing1771737_reint_roducing_
reinviting1446217_rein___vi_ting_
reiterating12410497_rei_ter__ating_
reservicing1753427_re__servi_cing_
retrieving1445297_re__t_r_ieving_
reviewing1635517_r____e_viewing_
televiewing1851917_te__le_viewing_
winterfeeding2162227__winterfeeding_
winterizing2446057__winter_i_zing_

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 Filter178691950240.1261418182.5
2DLD Change Limit95024658.81310782.3
3Display Results65650.0461413.0
 (SQL Overall)178691658.98519887.7
 
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.